How to Pull Code Violation County Data for Sedgwick County, KS

The fields you get

• Case number
• Case type code
• Case status
• Address
• City
• ZIP
• Parcel ID
• Processed date
• Case description (CASEDESC)

Follow these 5 steps

1. 1

   Open the Code Enforcement Violations page

   Go to Code Enforcement Violations. This is a plain city data page. It shows the list of columns.

   Enlarge
2. 2

   Open the query form

   Scroll to the bottom of the page. Click the link Query.

   Enlarge
3. 3

   Fill the top of the form

   In Where type CaseStatus='Active'. In Out Fields type CaseNumber,CaseType,CaseStatus,Address,City,ZipCode,ParcelID,ProcessedDate.

   Enlarge
4. 4

   Fill the bottom of the form

   In Order By Fields type ProcessedDate DESC. Set Format to HTML. Click Query (GET).

   Enlarge
5. 5

   Copy your records

   The page shows # records, then one block per case. We saw 969 active cases. Select the blocks you need and paste them into a sheet.

   Enlarge

Watch out for these

• There is no download button. You copy from the screen.
• The date shows as a long number. In Excel, put this formula next to it to get a real date: =A1/86400000+25569. Change A1 to your cell and format the result as a date.
• Parcel ID is often 0. Use the address to find the owner on the county site.
• The site may not open from every country. In our test it timed out from the Philippines and opened from the US.
• The old FeatureServer link gives an error now. Use the MapServer link in this guide.
• The page shows up to 2,000 records at a time. Narrow the Where box if you hit that number.

Other lists in Sedgwick County

We only have this list for Sedgwick County so far. See all Kansas guides.