NET Cases

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id 37zz-93tg
Name NET Cases
Attribution Austin Code Department
Category Government
Created 2015-08-04T16:16:15Z
Publication Date 2017-01-11T13:13:42Z

Description

This dataset is used to provide case data to the NET dashboard.

Columns

| Included | Schema Type    | Field Name                 | Name                       | Data Type     | Render Type   |
| ======== | ============== | ========================== | ========================== | ============= | ============= |
| Yes      | numeric metric | folderrsn                  | FOLDERRSN                  | number        | number        |
| Yes      | series tag     | casenumber                 | CASENUMBER                 | text          | text          |
| Yes      | time           | date_opened                | DATE_OPENED                | calendar_date | calendar_date |
| No       |                | date_closed                | DATE_CLOSED                | calendar_date | calendar_date |
| Yes      | series tag     | case_type                  | CASE_TYPE                  | text          | text          |
| Yes      | series tag     | inspector_name             | INSPECTOR_NAME             | text          | text          |
| Yes      | series tag     | status                     | STATUS                     | text          | text          |
| Yes      | series tag     | primary_reported_violation | PRIMARY_REPORTED_VIOLATION | text          | text          |
| Yes      | numeric metric | propx                      | PROPX                      | number        | number        |
| Yes      | numeric metric | propy                      | PROPY                      | number        | number        |
| No       |                | last_update                | LAST_UPDATE                | calendar_date | calendar_date |
| No       |                | address                    | ADDRESS                    | text          | text          |
| No       |                | longitude                  | LONGITUDE                  | number        | number        |
| No       |                | latitude                   | LATITUDE                   | number        | number        |

Time Field

Value = date_opened
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = date_closed,last_update,address,longitude,latitude

Data Commands

series e:37zz-93tg d:2015-04-13T00:00:00.000Z t:casenumber="2015-041977 CC" t:status=Closed t:primary_reported_violation="Structure Condition Violation(s)" t:case_type=Commercial t:inspector_name="Stephen Oswalt" m:folderrsn=11328768 m:propy=10108747 m:propx=3121108.75

series e:37zz-93tg d:2015-04-13T00:00:00.000Z t:casenumber="2015-042033 CC" t:status=Closed t:primary_reported_violation="Structure Condition Violation(s)" t:case_type=Commercial t:inspector_name="Stephen Oswalt" m:folderrsn=11328834 m:propy=10109011 m:propx=3121148

series e:37zz-93tg d:2015-04-13T00:00:00.000Z t:casenumber="2015-042040 CC" t:status=Closed t:primary_reported_violation="Structure Condition Violation(s)" t:case_type=Commercial t:inspector_name="Ron Russell" m:folderrsn=11328841 m:propy=10104262 m:propx=3130039

Meta Commands

metric m:folderrsn p:integer l:FOLDERRSN t:dataTypeName=number

metric m:propx p:double l:PROPX t:dataTypeName=number

metric m:propy p:double l:PROPY t:dataTypeName=number

entity e:37zz-93tg l:"NET Cases" t:attribution="Austin Code Department" t:url=https://data.austintexas.gov/api/views/37zz-93tg

property e:37zz-93tg t:meta.view v:id=37zz-93tg v:category=Government v:averageRating=0 v:name="NET Cases" v:attribution="Austin Code Department"

property e:37zz-93tg t:meta.view.owner v:id=bci6-zyu7 v:screenName=Shawn v:displayName=Shawn

property e:37zz-93tg t:meta.view.tableauthor v:id=bci6-zyu7 v:screenName=Shawn v:roleName=editor v:displayName=Shawn

Top Records

| folderrsn | casenumber     | date_opened         | date_closed         | case_type   | inspector_name | status | primary_reported_violation       | propx         | propy         | last_update         | address              | longitude    | latitude    | 
| ========= | ============== | =================== | =================== | =========== | ============== | ====== | ================================ | ============= | ============= | =================== | ==================== | ============ | =========== | 
| 11328768  | 2015-041977 CC | 2015-04-13T00:00:00 | 2015-04-22T00:00:00 | Commercial  | Stephen Oswalt | Closed | Structure Condition Violation(s) | 3121108.75    | 10108747      | 2015-04-22T00:00:00 | 1910 WEST LOOP       | -97.71845718 | 30.37206716 | 
| 11328834  | 2015-042033 CC | 2015-04-13T00:00:00 | 2015-06-13T00:00:00 | Commercial  | Stephen Oswalt | Closed | Structure Condition Violation(s) | 3121148       | 10109011      | 2015-05-12T00:00:00 | 2010 WEST LOOP       | -97.71831307 | 30.37279032 | 
| 11328841  | 2015-042040 CC | 2015-04-13T00:00:00 | 2015-06-29T00:00:00 | Commercial  | Ron Russell    | Closed | Structure Condition Violation(s) | 3130039       | 10104262      | 2015-04-29T00:00:00 | 503 E RUNDBERG LN    | -97.69048451 | 30.35915840 | 
| 11328846  | 2015-042045 CC | 2015-04-13T00:00:00 | 2015-06-13T00:00:00 | Commercial  | Stephen Oswalt | Closed | Structure Condition Violation(s) | 3130293.86    | 10103581.52   | 2015-04-29T00:00:00 | 700 MIDDLE LN        | -97.68972793 | 30.35727123 | 
| 11329062  | 2015-042238 CC | 2015-04-14T00:00:00 | 2015-05-20T00:00:00 | Multifamily | Stephen Oswalt | Closed | Structure Condition Violation(s) | 3128227.15063 | 10099667.4737 | 2015-05-20T00:00:00 | 8312 N IH 35 SVRD SB | -97.69657291 | 30.34664705 | 
| 11329072  | 2015-042244 CC | 2015-04-14T00:00:00 | 2015-04-22T00:00:00 | Multifamily | Stephen Oswalt | Closed | Structure Condition Violation(s) | 3126671.5     | 10098863      | 2015-04-22T00:00:00 | 8033 GESSNER DR      | -97.70156365 | 30.34453697 | 
| 11329086  | 2015-042258 CC | 2015-04-14T00:00:00 | 2015-11-09T00:00:00 | Multifamily | Ron Russell    | Closed | Structure Condition Violation(s) | 3127406       | 10099795      | 2015-05-17T00:00:00 | 8215 SAM RAYBURN DR  | -97.69916585 | 30.34705108 | 
| 11329091  | 2015-042263 CC | 2015-04-14T00:00:00 | 2015-06-08T00:00:00 | Multifamily | Robert Moore   | Closed | Structure Condition Violation(s) | 3131708.25    | 10107360      | 2015-04-20T00:00:00 | 10204 BROWNIE DR     | -97.68495956 | 30.36756512 | 
| 11329112  | 2015-042282 CC | 2015-04-14T00:00:00 | 2015-11-18T00:00:00 | Multifamily | Robert Moore   | Closed | Work Without Permit              | 3131951.25    | 10107221      | 2015-04-20T00:00:00 | 10207 BROWNIE DR     | -97.68419974 | 30.36716713 | 
| 11329117  | 2015-042287 CC | 2015-04-14T00:00:00 | 2015-05-06T00:00:00 | Multifamily | Jim Richerson  | Closed | Property Abatement               | 3131553.25    | 10106969      | 2015-05-01T00:00:00 | 10104 BROWNIE DR     | -97.68548042 | 30.36650048 |