Crime Data Warehouse database request
Tracking # |
P012462-062820 |
Submitted | June 26, 2020 |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Anonymous
To Whom It May Concern:
Pursuant to the California Public Records Act, I hereby request the following records:
Below are new Immediate Disclosure Requests (SF Admin Code 67.25(a)) directed to your agency and its department head. Your response is required by June 30, 2020. Rolling records responses are requested (SFAC 67.25(d)) if you are unable to immediately produce records.
1. The data dictionary for the entire Crime Data Warehouse including the person schema.
2. All person data from the Crime Data Warehouse (including but not limited to race, gender, age and any other available fields) along with incident numbers and dates for all incidents from January 15, 2020 - June 15th, 2020 (inclusive). Please have IT extract this data from the database into spreadsheet(s). See this spreadsheet for an example of person data which has previously been released by your department (though please note that this request is different in scope): https://cdn.muckrock.com/foia_files/2020/06/16/Arrest_Person___Incident_For_Release.xlsx
3. Any documents describing how the public can access "person data" from the Crime Data Warehouse on SFGOV.org or any other publicly available website.
Pursuant to SF Admin Code 67.21(l), which requires you to use any electronic format that we request, please provide the records for 1. and 2. in spreadsheet format.
The requested documents will be made available to the general public, and this request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 calendar days, as the statute requires.
Sincerely,
Anonymous
From: San Francisco Police Department
Dear Anonymous Anonymous:
Thank you for your interest in public records of the San Francisco Police Department ("SFPD").
The San Francisco Police Department ("SFPD") received your request, dated June 28, 2020 and given the reference number P012462-062820 for tracking purposes.
Record(s) Requested: To Whom It May Concern:
Pursuant to the California Public Records Act, I hereby request the following records:
Below are new Immediate Disclosure Requests (SF Admin Code 67.25(a)) directed to your agency and its department head. Your response is required by June 30, 2020. Rolling records responses are requested (SFAC 67.25(d)) if you are unable to immediately produce records.
1. The data dictionary for the entire Crime Data Warehouse including the person schema.
2. All person data from the Crime Data Warehouse (including but not limited to race, gender, age and any other available fields) along with incident numbers and dates for all incidents from January 15, 2020 - June 15th, 2020 (inclusive). Please have IT extract this data from the database into spreadsheet(s). See this spreadsheet for an example of person data which has previously been released by your department (though please note that this request is different in scope): https://cdn.muckrock.com/foia_files/2020/06/16/Arrest_Person___Incident_For_Release.xlsx
3. Any documents describing how the public can access "person data" from the Crime Data Warehouse on SFGOV.org or any other publicly available website.
Pursuant to SF Admin Code 67.21(l), which requires you to use any electronic format that we request, please provide the records for 1. and 2. in spreadsheet format.
The requested documents will be made available to the general public, and this request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 calendar days, as the statute requires.
Sincerely,
Anonymous
Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/
Your request is being forwarded to the appropriate department(s) for processing and you will be notified once the request is complete.
You can monitor request progress at the link below. Thank you for using the San Francisco Public Records Center.
San Francisco Police Department
From: San Francisco Police Department
--- Please respond above this line ---
June 29, 2020
Via email requests@muckrock.com
Anonymous Anonymous
MuckRock News DEPT MR 97053 411A Highland Ave
Somerville, MA 02144
RE: Public Records Request, dated June 28, 2020, Reference # P012462-062820
Dear Anonymous Anonymous:
In response to your request, please see attached document(s).
Sincerely,
Lieutenant R. Andrew Cox #287
Officer in Charge
Risk Management - Legal Division
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.
From: San Francisco Police Department
Attachments:
BI_Data_Dictionary_SFPD_PERSONS.xlsx (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFs2KguIDF883TvKUiL5Czauo89OcQL1XvHpyaOEmJgddhTktxCQo3dAEL3UN6JwjbrIOEhWaSG1hipJN4KjQBAgXqfYGkpPWEwxh8jt2QAiuwb5VD9AIg8XMYyQ9gkRhdyEZdZO4flgjoLeauYYDgoqWp5hAJL7aCDntW0zA9V1S3KsNNTM2rSna1o-2BxjnJT6tPyqqGFrRIQFSfioLuD3Bs-3DXlrh_w0SB4dJ3fBcC9FTXszZb0My-2Feoyh7nH9bvvyqSJSIYY-2BbkAHRNx0UwY3ynHcTTt5osyImb4JoaSDwX8ggi-2F55Xy-2BCtRVrN69CaP0HJP9b7a7OErzneLtcaMeGlKci9X8-2BvkQDEOjGapNVmnFOHq-2BXWyv4hGDdN1nnVf0L-2F6a35qWDvOaK0MFvmGENWWA2Qp6qHxMesBroK-2BT71gR5C5PuVWJZ7B-2Fe4m3gZp3w-2BXCi39lkrDkSUGdAR4488zR2xe8ZH6T6WA28hRy1vopQEB5UIU8w10n-2BThOSIxqcz-2FXbok0B8XzBN0dcIqu-2F-2Bj7-2BicZSBJYeKhIl2f39UUQe8EGHasulBs63tfkgpnbYgfuG-2BK54nxEnMbLYSlCPq55oozra85EUj8Nj63LVQZAT-2FZnYw-3D-3D)
Final.xlsx (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFs2KguIDF883TvKUiL5Czauo89OcQL1XvHpyaOEmJgddhTktxCQo3dAEL3UN6JwjbrIOEhWaSG1hipJN4KjQBAgXqfYGkpPWEwxh8jt2QAiuMeac0n-2F3y5J4Tlu46ecbVSnMr3LVmm-2B5-2Bt8JLqCRg1c4-2B-2Bzx8ltg88k4IOyQSqBqTbDfkMt4WoF6nG6u9mK7YBhw15AQyxKahye9YHxv8po-3DdfEf_w0SB4dJ3fBcC9FTXszZb0My-2Feoyh7nH9bvvyqSJSIYY-2BbkAHRNx0UwY3ynHcTTt5osyImb4JoaSDwX8ggi-2F55Xy-2BCtRVrN69CaP0HJP9b7a7OErzneLtcaMeGlKci9X8-2BvkQDEOjGapNVmnFOHq-2BXWyv4hGDdN1nnVf0L-2F6a35qWDvOaK0MFvmGENWWA2Qp6qHxMesBroK-2BT71gR5C5PuVWJZ7B-2Fe4m3gZp3w-2BXCi39lkrDkSUGdAR4488zR2xe8DQ185kqS1EWWLBZmLKA5UcPwbYbb5zizXyfNNbQn-2F7sCipPlQta0KA2LHxs83B9EDZA401dv6GcLp0PvHov-2BRPJSGx2Wv8KFxCsGBbqJt4i4F9K8CTptXl1m6cm6CRyf3VO0i-2Fiye8q7evlrH-2FX0lg-3D-3D)
P12462_-_2020.07.07_sfpd_response.pdf (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFs2KguIDF883TvKUiL5Czauo89OcQL1XvHpyaOEmJgddhTktxCQo3dAEL3UN6JwjbrIOEhWaSG1hipJN4KjQBAgXqfYGkpPWEwxh8jt2QAiunuroMTIMubTMiH8T2yNMAXOyFCG7V9fPx8InAvbCyscg2J6kkjQsB5CQ0H7hZg18Ig2Ikrh8z67q4C0OZxS3V2JqLxFwMf9t9eAsByuuSLY-3Dia67_w0SB4dJ3fBcC9FTXszZb0My-2Feoyh7nH9bvvyqSJSIYY-2BbkAHRNx0UwY3ynHcTTt5osyImb4JoaSDwX8ggi-2F55Xy-2BCtRVrN69CaP0HJP9b7a7OErzneLtcaMeGlKci9X8-2BvkQDEOjGapNVmnFOHq-2BXWyv4hGDdN1nnVf0L-2F6a35qWDvOaK0MFvmGENWWA2Qp6qHxMesBroK-2BT71gR5C5PuVWJZ7B-2Fe4m3gZp3w-2BXCi39lkrDkSUGdAR4488zR2xe82WEyWEgDZth8wVT04NmMGNqOs6pZvaJzr4HABUr-2FLoQCpDTuIGy4OOC65eF2UiEc3BBbpr58TYZD98Tebt4ZZgmZglAke-2B0B-2B0VIuq-2BhPAkMM06rmSzeasY1vcY-2BD1FLtYaL0YPkAyOYYIG9MYaZ7Q-3D-3D)
PRA_-_CDW_Person_Schema.pdf (https://u8387795.ct.sendgrid.net/ls/click?upn=nZGH0ylxadMp5hTpNkeAFs2KguIDF883TvKUiL5Czauo89OcQL1XvHpyaOEmJgddhTktxCQo3dAEL3UN6JwjbrIOEhWaSG1hipJN4KjQBAgXqfYGkpPWEwxh8jt2QAiuMeac0n-2F3y5J4Tlu46ecbVSnMr3LVmm-2B5-2Bt8JLqCRg1esoG1qg50-2BXQYLOGKIQAjuDfh5hdv-2B-2FTAr2zkEANJdiKZSx8kbjPKg99iIEsVm6KQ-3D6OXQ_w0SB4dJ3fBcC9FTXszZb0My-2Feoyh7nH9bvvyqSJSIYY-2BbkAHRNx0UwY3ynHcTTt5osyImb4JoaSDwX8ggi-2F55Xy-2BCtRVrN69CaP0HJP9b7a7OErzneLtcaMeGlKci9X8-2BvkQDEOjGapNVmnFOHq-2BXWyv4hGDdN1nnVf0L-2F6a35qWDvOaK0MFvmGENWWA2Qp6qHxMesBroK-2BT71gR5C5PuVWJZ7B-2Fe4m3gZp3w-2BXCi39lkrDkSUGdAR4488zR2xe8pMnEvCYke4kdMJcpBfOoVM3nxWzeM9BG68TbLo8PKSjkpcwG9iZ-2BgNUKdO33uaj6phxOMntoFvjQvSCRVieUWUGUifq6T-2BDsazhTOJznnpyYQy-2FV38ae28ddgxgwRSqXQEc7ooL7KJ3xxNOFBEpWow-3D-3D)
--- Please respond above this line ---
July 07, 2020 Via email requests@muckrock.com
Anonymous Anonymous
MuckRock News DEPT MR 97053 411A Highland Ave
Somerville, MA 02144
RE: Public Records Request, dated June 28, 2020, Reference # P012462-062820
Dear Anonymous Anonymous:
In response to your request, please see attached documents.
If you have any questions, please contact Briseida Walton at 415-837-7180.
Thank you for your attention.
Sincerely,
Lieutenant R. Andrew Cox #287
Officer in Charge
Risk Management - Legal Division
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.
Files
pages