Roster database schemas

Rose Terse

Thank you for your interest in public records of the City of Spokane.  Your request has been received and is being processed.  Your request was received in this office on June 05, 2023 and given the reference number P006002-060523 for tracking purposes.
Date/Date Range Start:
Date Range End:
Description of Records Requested: To Whom It May Concern:

Pursuant to the Washington Public Records Act, I hereby request the following records:

Database schemas of all tables in the database used to produce the roster CSV in request P011870-122122.

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 5 business days, as the statute requires.

Sincerely,

Rose Terse

Upload documents directly: https://www.muckrock.com/

Your request will be forwarded to the relevant City department(s) to locate the records you seek and to determine the volume and any costs associated with satisfying your request.  You will be contacted about the availability of the records in question.
You can monitor the progress of your request at the link below and you'll receive an email when your request has been completed.  Again, thank you for using the Spokane Records Center.
City of Spokane

--- Please respond above this line ---
If you wish to submit a response, update an existing request, check the status of an already submitted request, or submit a new public records request, please do so by replying to this notification or go through your “My Request Center” account on the City’s public records request portal (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HSVD4CrS9uFW2stupoI-2F3P-2FCR9v4w4dDGSabyWOuZGyK73EIPwhayp6yerTiw-2FMwyAatRlrvnO7ENj4b1rLl3GE-3Dpo1Y_IZunBYNQYiAkeKL0R5YUxLotFicIZALbrSvf05AG5SfcS49NDdvWpdtmeWervig26HyofAz6YawzjS0cKmg5i-2FNFEEenQhzRVpIM18dCoFtr8E8ZaBkN84eg3kQpqobFOraZTOF2t6UXhR6LpTx-2BunPrhFPcoqxeiBOCyJEyE3wH9IErjSW07Xi9GybAO0-2FZJuxLBuccbmyWibO0WeIMqcpcaTSbKbHQyS2UxNe5rj9RvRYlb2yuViHqZpQkMICQRpi8Iv1lvuY6mg0fK6e3WzTiJoujqeGpKoIcneqq5ZaImwVIlytz6-2FrARoLderD-2BzKhIIaHiB3Z7S1ZTqubLfXciLSaR04FSr6f2VmzSDV3pdS8w8O3aHo6WSMBzddjA52nQ4Sljz2GjhDhUsg9-2FPQ-3D-3D)
In accordance with the Public Records Act (PRA), RCW 42.56.520, this message acknowledges receipt of your PRA request, received by the City of Spokane on June 5, 2023.  This request has been assigned tracking number P006002-060523.  Please use this number in any communications concerning this request.
Specifically, you requested: To Whom It May Concern:”

Pursuant to the Washington Public Records Act, I hereby request the following records:

Database schemas of all tables in the database used to produce the roster CSV in request P011870-122122.

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 5 business days, as the statute requires.

Sincerely,

Rose Terse

Upload documents directly: https://www.muckrock.com/
Our procedure is to locate records, review them for exemptions, and then prepare them for your inspection and/or copying.  The undersigned will be coordinating with other City departments in the collection and production of responsive records.
Your request has been forwarded to staff in the Spokane Police Department for review and compiling of any responsive records.  We anticipate an installment will be available on or about June 20, 2023.  We will follow up with you on or about that date regarding the status of your request.  If public records become available in advance of this estimate, we will let you know.  Conversely, if City staff encounters a need to extend our estimate, we will advise accordingly.
Sincerely,
Laurie Farnsworth
Spokane Deputy City Clerk

--- Please respond above this line ---
If you wish to submit a response, update an existing request, check the status of an already submitted request, or submit a new public records request, please do so by replying to this notification or go through your “My Request Center” account on the City’s public records request portal
In accordance with the Public Records Act (PRA), RCW 42.56.520, this message acknowledges receipt of your PRA request, received by the City of Spokane on June 5, 2023.  This request has been assigned tracking number P006002-060523.  Please use this number in any communications concerning this request.
Specifically, you requested: To Whom It May Concern:”

Pursuant to the Washington Public Records Act, I hereby request the following records:

Database schemas of all tables in the database used to produce the roster CSV in request P011870-122122.

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 5 business days, as the statute requires.

Sincerely,

Rose Terse

Upload documents directly: https://www.muckrock.com/
In response to your request, this is to inform you that a document located by staff from the Spokane Police Department is available by accessing your account via the My Request Center on the City's GovQA portal.
Does this document satisfy the intent of your request?  If it does not and you are seeking additional records from the City, or, if you have personal knowledge of any responsive records in the City's possession that have not yet been made available to you, please clarify your request by clearly describing what the remaining identifiable public records are, if any, that you may still be attempting to seek, and we will be glad to look into your request further.
Please provide any such clarification within 30 days of today's date, or by July 21, 2023.  If no clarification is received from you by that date, your request will be considered concluded and closed, and a new request will be required in this matter after July 21.
Sincerely,
Laurie Farnsworth
Spokane Deputy City Clerk

--- Please respond above this line ---
If you wish to submit a response, update an existing request, check the status of an already submitted request, or submit a new public records request, please do so by replying to this notification or go through your “My Request Center” account on the City’s public records request portal
Good morning:
This is a follow up to my June 21 correspondence to you regarding your public records request assigned tracking number P006002-060523, and is also to acknowledge your messages dated June 22 and September 19.  I regret that your June 21 message was inadvertently overlooked.  Your inquiry has been forwarded to staff in the Spokane Police Department for further review.  I anticipate following up with you in this regard in approximately one week, or on or about September 27.  If I am able to follow up with you sooner, I will let you know.
Sincerely,
Laurie Farnsworth
Spokane Deputy City Clerk

--- Please respond above this line ---
If you wish to submit a response, update an existing request, check the status of an already submitted request, or submit a new public records request, please do so by replying to this notification or go through your “My Request Center” account on the City’s public records request portal (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HSVD4CrS9uFW2stupoI-2F3P-2FCR9v4w4dDGSabyWOuZGyK73EIPwhayp6yerTiw-2FMwyAatRlrvnO7ENj4b1rLl3GE-3Ds3nC_IZunBYNQYiAkeKL0R5YUxLotFicIZALbrSvf05AG5SfcS49NDdvWpdtmeWervig26HyofAz6YawzjS0cKmg5ixjFqLB27ftm2Zl2JBKrxM2coBad78XSfqcKrzDCH75NNTZFBGqPZfJ-2FAmomzzEcvztrXR4zzYuz6D5uBPQnLwGWbAx9qtIr5-2FMeou4C5qRyKz3LsjHquSk6EK3KOL7AEDTjvAiZsNUqSZ3pVcKNK3f9k1XIot-2BITj8KYb5wkf9GDnFy8XURTbWfb6Y5a9rBLdohBq3uw0jGA-2FvMCBikOPaxBk5jnyQu4dJblZ-2BZz9OL-2B6HmCk0wJcH-2FlCvsV3qIEeAsWIuhnri7sPvH5PZunVvfinpPfgrNGfIQWz8c4L0zhE3hMlesS6vI2jvyGvokaw-3D-3D)
Good evening Rose:
In follow up to my September 20 correspondence to you regarding your public records request assigned tracking number P006002-060523, the following clarification was provided by staff from the Spokane Police Department:
The following table and columns relate to the roster columns.

[Resource_Tbl].Rsc_Name_Ch -- Name
[Job_Title_Tbl].Job_Name_Ch -- Rank
[Resource_Master_Tbl].RscMaster_EmployeeID_Ch -- [Badge #]
[Resource_Master_Tbl].RscMaster_PayrollID_Ch -- [City ID]
[Station_Tbl].station_name_ch -- Assignment
Please advise if this information addresses your June 22 and September 19 inquiries.  If you are seeking additional records from the City, please further clarify your request by clearly describing what the remaining identifiable public records are, if any, that you may still be attempting to seek, and we will be glad to look further into this matter.
Please provide any such clarification within 30 days of today's date, or by October 23, 2023.  If no further clarification is received from you by that date, your request will be considered concluded and closed, and a new request will be required in this matter after October 23.
Sincerely,
Laurie Farnsworth
Spokane Deputy City Clerk