Information wrt DBMSs (Information Technology, Pennsylvania)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology, Pennsylvania of Philadelphia, PA.
Due July 25, 2018
Est. Completion None
Status
Awaiting Response

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the Pennsylvania Right to Know Act, I hereby request the following records:

For all DBMSs owned, maintained, operated, contracted with/through, or supported by the Information Technology - or similar - department(s) within your city, please provide me with the following information:

-Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
-Names of software that connect to each DBMS
-Names of departments that use information within the DBMS
-Schema of database (preferably, with granularity down to column names)
-Contract identifier for each database, if relevant

I understand that the information respondent to this request may require the creation of new documents - if that will be the case, then please provide me with documents that may contain the information (eg, documentation, contracts, etc). I am also happy to narrow the scope of my request if necessary.

Please also let me know if any help is needed with discovering any DBMS services. My background is in distributed systems systems administration and I can offer technical tips or advice if it would be helpful in any way.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes. As I believe the information respondent to this request outweighs the costs and burden, I would like to kindly request a fee waiver.

I look forward to receiving your response to this request within 5 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Information Technology, Pennsylvania

CITY OF PHILADELPHIA LAW DEPARTMENT One Parkway Building 1515 Arch Street Philadelphia, PA 19102 Marcel S. Pratt City Solicitor  BY EMAIL: requests@muckrock.com Re: FW: MuckRock News Requests Request #: 2444 Dear Matt Chapman: Thank you for writing to the City of Philadelphia (“City”) with your request for information. A brief description of your request(s) as well as the City’s internal tracking number can be found below. This letter serves as an acknowledgement of receipt of your request and notice of the City’s Open Records Policy pursuant to the Right to Know Law. Please note at the outset that written requests for records to state and local agencies in Pennsylvania are generally governed by the Commonwealth’s Right to Know Law (the “Act” or “RTK Law”), 65 P.S. §§ 67.101-67.3104. In accordance with the Act, the City has promulgated an Open Records Policy, which requires the standard statewide Right to Know Form be used for the submission of written requests pursuant to the Act (“RTK Requests”). See 65 P.S. § 67.504(a); Dekok v. Lancaster County, AP 2010-1197, 2011 PA O.O.R.D. LEXIS 25 at *5 and n.1 (Pa. O.O.R. Jan. 17, 2011) (holding that in accordance with the Right to Know Law, an agency may adopt a policy requiring the use of the standard statewide form established by the Office of Open Records in order to file a Right to Know Request); accord Pa. Gaming Control Bd. v. Office of Open Records, 48 A.3d 503 (Pa. Cmmw. 2012). As your request was not submitted on or with the standard statewide form, the City does not consider your request to be a RTK Request pursuant to the Act and will process it as an informal request. You do not have to resubmit your request for the City to respond unless you are specifically informed otherwise. The City reserves the right to require a formal RTK Request be submitted pursuant to the Act before releasing records. The City is continuing to process the request you have submitted as an informal request outside the Act and will be in touch with you further to respond to your request. However, if you would like to file a RTK Request, please submit your request on or with the standard statewide Right to Know Form and address your request to the appropriate open records officer in accordance with the City’s Right to Know Policy.  Please include this notice with your RTK Request. Please note that if you resubmit your request as a written request pursuant to the Act the City will deem your informal request to have been withdrawn.  The City’s Open Records Policy can be found here:  http://www.phila.gov/privacy/pdfs/FinalCityOpenRecords.pdf The statewide form appears at the end of the City’s Right to Know Policy. If you require a hard copy of the form and/or policy, please let me know and one will be provided. The City reserves the right to assert any and all grounds of denial in its final response to your request. Respectfully, Jill I. Freeman Deputy City Solicitor (215) 683-5069 (fax) Tracking #: Chapman 2444 Request Summary: Various software information regarding any DBMS's owned or operated by OIT. Original Request:
Rec’d: 8/27/18




 


Ticket attachments :
1. RTK Request - MuckRock News (8-2018).pdf 2. RTK Request #2 - MuckRock News (8-2018).pdf

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

Dear Mr. Chapman, Attached please find the final response to your request for information. Thank you,
Robert L. Kieffer
Assistant City Solicitor
(215) 683-5032 (Tel.)
(215) 683-5069 (fax)

From: Matt Chapman - Free Our Info, NFP

Could you please provide me with more information as to why the information would be reasonably likely to jeopardize your security? To suggest those those records are likely to jeopardize your security is not unlike claiming that a request for the labels on a filing cabinet would jeopardize security.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

From: Information Technology, Pennsylvania

THE CITY OF PHILADELPHIA Dear Matt Chapman,

Thank you for your correspondence. This is an automatic response to let you know that the City will process your request and respond further within 5 business days of its receipt by an Open Records Officer. Please note that requests received after 5PM are deemed received the next business day. If you do not receive an email within 5 business days, please contact the City immediately as occasionally a requester's spam blocking service interferes with the delivery of our emails and we are not aware of the issue.  Did you know that the City already releases a lot of information and open data online? You might be able to find the answer to your inquiry right now!


Here are some common types of requests we receive and where to find this information online right now:  

Search for a property's L&I related permits, licenses, violations, and appeals with the L&I property history tool. 

Search for a property's Real Estate Tax Balance with the Revenue Department's tax real estate lookup tool. 

Find all of the City of Philadelphia's open data sets, including City employee salary data, on Open Data Philly, the Philadelphia region's open data portal. 

Search information about professional service contracts online at eContract Philly. 

Search information about procurement contracts online with PHL Contracts. 

Search City legislation and related hearings online with Legistar. 

Obtain financial disclosure forms from the Department of Records. 


If you are seeking a police incident report, you can obtain the proper form from the Department of Records. Please note that police incident reports cost $25.00.  The City of Philadelphia is often confused with other entities, such as the ones below. If you want to submit a request to one of these entities, please click the links below to be directed to their Open Records Policies: 

Philadelphia Parking Authority 


School District of Philadelphia 


City of Philadelphia District Attorney’s Office 


Philadelphia Redevelopment Authority 


First Judicial District (Philadelphia Court of Common Pleas) 


If one of these sources has solved your inquiry, please let us know! Otherwise, thank you for your patience, and we will be in touch soon.  Sincerely, The City of Philadelphia Please Note: To help make sure that future emails from us don't end up in your spam or junk folder, please add this email address to your safe sender list.

Files

pages

Close