trees
50 rows where Fire Prevention Districts = 8 and qSpecies_id = 129 sorted by Police Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108926 | 14097 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1455 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2016 12:00:00 AM | 3 | 4X4 | Permit Number 778907 | 6007200 | 2110540 | 37.7755474375327 | -122.418576120309 | (37.7755474375327, -122.418576120309) | 8 | 2 | 9 | 28853 | 34 | |
113179 | 256659 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1455 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2018 12:00:00 AM | 3 | Permit Number 781724 | 6007354.4656 | 2110676.258 | 37.7759302643824 | -122.418051446991 | (37.7759302643824, -122.418051446991) | 8 | 2 | 9 | 28853 | 34 | ||
115149 | 13953 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1117 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 07:38:00 AM | 3 | 4X4 | 6008897.3784125 | 2112157.6718266 | 37.7800845945909 | -122.412818850612 | (37.7800845945909, -122.412818850612) | 8 | 2 | 9 | 28853 | 34 | ||
169880 | 91018 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 95 McCoppin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006069.437314 | 2109106.791352 | 37.771548477703 | -122.422385159744 | (37.771548477703, -122.422385159744) | 8 | 2 | 9 | 28853 | 19 | |||
2614 | 22945 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 446 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006123.08894 | 2106987.22573 | 37.7657316814476 | -122.422048975848 | (37.7657316814476, -122.422048975848) | 8 | 4 | 5 | 28853 | 19 | |||
4925 | 99065 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 560 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | 8 | 4 | 5 | 28859 | 19 | |||
11230 | 26974 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 680 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2018 12:00:00 AM | 3 | 3x6 | 6006189.7137 | 2105638.02498 | 37.7620308514509 | -122.421722694966 | (37.7620308514509, -122.421722694966) | 8 | 4 | 5 | 28859 | 19 | ||
11699 | 99056 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 524 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006116.39403 | 2106513.26367 | 37.7644299160351 | -122.422038458941 | (37.7644299160351, -122.422038458941) | 8 | 4 | 5 | 28859 | 19 | |||
22164 | 99062 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 548 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006124.33398 | 2106369.96474 | 37.7640368987846 | -122.422000816338 | (37.7640368987846, -122.422000816338) | 8 | 4 | 5 | 28859 | 19 | |||
31748 | 22958 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 474 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1994 12:00:00 AM | 3 | 3x3 | 6006107.21525 | 2106877.76556 | 37.7654302344215 | -122.422096102646 | (37.7654302344215, -122.422096102646) | 8 | 4 | 5 | 28853 | 19 | ||
32387 | 99071 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 567 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006238.66511 | 2106285.80349 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | 8 | 4 | 7 | 28859 | 19 | |||
32594 | 99080 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 515 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775410 | 6006223.31377 | 2106562.86626 | 37.7645721427534 | -122.421672175812 | (37.7645721427534, -122.421672175812) | 8 | 4 | 7 | 28859 | 19 | ||
41627 | 99060 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 544 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006121.99737 | 2106412.13789 | 37.7641525645269 | -122.422011894129 | (37.7641525645269, -122.422011894129) | 8 | 4 | 5 | 28859 | 19 | |||
45966 | 99079 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 521 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006248.76253 | 2106537.76034 | 37.7645046428221 | -122.421582372033 | (37.7645046428221, -122.421582372033) | 8 | 4 | 7 | 28859 | 19 | |||
46036 | 99063 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 560 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | 8 | 4 | 5 | 28859 | 19 | |||
48024 | 99078 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 523 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006225.8049 | 2106517.90539 | 37.764448831279 | -122.42166036603 | (37.764448831279, -122.42166036603) | 8 | 4 | 7 | 28859 | 19 | |||
51333 | 60113 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 520 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1982 12:00:00 AM | 3 | 3x3 | 6006114.68734 | 2106544.06971 | 37.7645144058927 | -122.422046550542 | (37.7645144058927, -122.422046550542) | 8 | 4 | 5 | 28859 | 19 | ||
51380 | 99076 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 557 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.421504654052 | (37.764010124676, -122.421504654052) | 8 | 4 | 7 | 28859 | 19 | |||
58183 | 99095 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 657 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006266.81696 | 2105777.70576 | 37.7624187297216 | -122.421465944573 | (37.7624187297216, -122.421465944573) | 8 | 4 | 7 | 28859 | 19 | |||
63777 | 22953 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 460 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x6 | 6006126.2342864 | 2106915.2740853 | 37.7655342966506 | -122.422032984881 | (37.7655342966506, -122.422032984881) | 8 | 4 | 5 | 28853 | 19 | |||
71696 | 99064 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 560 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | 8 | 4 | 5 | 28859 | 19 | |||
75365 | 99096 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 623 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.421497624526 | (37.7627830341769, -122.421497624526) | 8 | 4 | 7 | 28859 | 19 | |||
82055 | 60112 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 475 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1982 12:00:00 AM | 3 | 3x3 | 6006207.18224 | 2106854.01331 | 37.7653706541631 | -122.421748651963 | (37.7653706541631, -122.421748651963) | 8 | 4 | 7 | 28853 | 19 | ||
82355 | 99075 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 559 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.421504654052 | (37.764010124676, -122.421504654052) | 8 | 4 | 7 | 28859 | 19 | |||
84042 | 99059 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 540 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006092.37899 | 2106431.2635 | 37.7642034084393 | -122.422115694531 | (37.7642034084393, -122.422115694531) | 8 | 4 | 5 | 28859 | 19 | |||
85040 | 99066 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 580 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x6 | 6006132.54262 | 2106221.80887 | 37.7636305606357 | -122.421961899774 | (37.7636305606357, -122.421961899774) | 8 | 4 | 5 | 28859 | 19 | |||
85374 | 59944 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 541 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006230.19236 | 2106438.71887 | 37.7642316511634 | -122.421639566353 | (37.7642316511634, -122.421639566353) | 8 | 4 | 7 | 28859 | 19 | ||
94062 | 22991 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 663 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/04/2010 12:00:00 AM | 5 | 3x3 | 6006244.58019 | 2105713.97043 | 37.7622424736555 | -122.421538326696 | (37.7622424736555, -122.421538326696) | 8 | 4 | 7 | 28859 | 19 | ||
124075 | 99093 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 677 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006238 | 2105632 | 37.762017031056 | -122.421555263176 | (37.762017031056, -122.421555263176) | 8 | 4 | 7 | 28859 | 19 | |||
130392 | 99070 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 581 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006252.26909 | 2106239.1087 | 37.7636848134857 | -122.421549031471 | (37.7636848134857, -122.421549031471) | 8 | 4 | 7 | 28859 | 19 | |||
132802 | 99067 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 580 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006132.54262 | 2106221.80887 | 37.7636305606357 | -122.421961899774 | (37.7636305606357, -122.421961899774) | 8 | 4 | 5 | 28859 | 19 | |||
135287 | 99068 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 580 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006132.54262 | 2106221.80887 | 37.7636305606357 | -122.421961899774 | (37.7636305606357, -122.421961899774) | 8 | 4 | 5 | 28859 | 19 | |||
139919 | 99045 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 455 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006201.54773 | 2106955.70931 | 37.7656495696033 | -122.421775364545 | (37.7656495696033, -122.421775364545) | 8 | 4 | 7 | 28853 | 19 | |||
143579 | 99061 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 548 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6006124.33398 | 2106369.96474 | 37.7640368987846 | -122.422000816338 | (37.7640368987846, -122.422000816338) | 8 | 4 | 5 | 28859 | 19 | |||
144128 | 99044 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 461 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006204.27673 | 2106906.45383 | 37.7655144795923 | -122.421762426609 | (37.7655144795923, -122.421762426609) | 8 | 4 | 7 | 28853 | 19 | |||
148534 | 22957 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 460 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006126.23429 | 2106915.27409 | 37.7655342966637 | -122.422032984869 | (37.7655342966637, -122.422032984869) | 8 | 4 | 5 | 28853 | 19 | |||
151336 | 99094 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 677 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6006238 | 2105632 | 37.762017031056 | -122.421555263176 | (37.762017031056, -122.421555263176) | 8 | 4 | 7 | 28859 | 19 | |||
162591 | 66767 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 623 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/1991 12:00:00 AM | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.421497624526 | (37.7627830341769, -122.421497624526) | 8 | 4 | 7 | 28859 | 19 | ||
163381 | 99055 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 502 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006083.07455 | 2106599.19361 | 37.7646639800831 | -122.422159807273 | (37.7646639800831, -122.422159807273) | 8 | 4 | 5 | 28859 | 19 | |||
164214 | 99058 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 540 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006092.37899 | 2106431.2635 | 37.7642034084393 | -122.422115694531 | (37.7642034084393, -122.422115694531) | 8 | 4 | 5 | 28859 | 19 | |||
169083 | 173938 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 680 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x6 | 6006196.3038013 | 2105654.3539825 | 37.7620760586794 | -122.421701062175 | (37.7620760586794, -122.421701062175) | 8 | 4 | 5 | 28859 | 19 | ||||
170188 | 99072 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 567 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006238.66511 | 2106285.80349 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | 8 | 4 | 7 | 28859 | 19 | |||
170724 | 99043 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 475 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006207.18224 | 2106854.01331 | 37.7653706541631 | -122.421748651963 | (37.7653706541631, -122.421748651963) | 8 | 4 | 7 | 28853 | 19 | |||
172381 | 99077 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 529 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006227.20287 | 2106492.6748 | 37.764379632857 | -122.421653738681 | (37.764379632857, -122.421653738681) | 8 | 4 | 7 | 28859 | 19 | |||
174252 | 84694 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 623 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.421497624526 | (37.7627830341769, -122.421497624526) | 8 | 4 | 7 | 28859 | 19 | |||
174882 | 99048 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 435 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006194.69309 | 2107079.42494 | 37.7659888769113 | -122.421807861739 | (37.7659888769113, -122.421807861739) | 8 | 4 | 7 | 28853 | 19 | |||
177030 | 22974 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 601X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1994 12:00:00 AM | 3 | 3x3 | 6006253.05747 | 2106023.17246 | 37.76309194781 | -122.421530967732 | (37.76309194781, -122.421530967732) | 8 | 4 | 7 | 28859 | 19 | ||
190226 | 99074 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 561 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.421504654052 | (37.764010124676, -122.421504654052) | 8 | 4 | 7 | 28859 | 19 | |||
191522 | 99073 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 567 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006238.66511 | 2106285.80349 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | 8 | 4 | 7 | 28859 | 19 | |||
194170 | 99057 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006091.16213 | 2106453.22967 | 37.7642636537255 | -122.422121463956 | (37.7642636537255, -122.422121463956) | 8 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );