trees
59 rows where Fire Prevention Districts = 15, SiteOrder = 1 and qSpecies_id = 5
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2297 | 16623 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | 15 | 5 | 5 | 28862 | 3 | |||
16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
18931 | 16634 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.433406271499 | (37.7664480128774, -122.433406271499) | 15 | 5 | 5 | 28862 | 3 | |||
19336 | 247504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.445142787454 | (37.7703040400286, -122.445142787454) | 15 | 5 | 11 | 29492 | 9 | |||
19461 | 138737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.445772761062 | (37.7853686673978, -122.445772761062) | 15 | 6 | 1 | 29490 | 31 | |||
21471 | 139360 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2807 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000073 | 2114379 | 37.7856845299005 | -122.443505885647 | (37.7856845299005, -122.443505885647) | 15 | 6 | 1 | 29490 | 31 | |||
22540 | 225094 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | 15 | 5 | 5 | 29492 | 9 | |
29498 | 225099 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.7706120358534 | -122.430685739554 | (37.7706120358534, -122.430685739554) | 15 | 9 | 11 | 29492 | 10 | |
32299 | 222920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998076.5165 | 2106905.97838 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | 15 | 5 | 11 | 29492 | 9 | |||
35932 | 222922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | 15 | 5 | 11 | 29492 | 9 | |||
36090 | 58566 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | 15 | 5 | 11 | 29492 | 9 | ||
47329 | 16647 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.60519 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | 15 | 5 | 5 | 28862 | 3 | ||
48301 | 225091 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | 15 | 5 | 5 | 28862 | 3 | |||
50058 | 103976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000022.661 | 2113372.9775 | 37.7829193814773 | -122.44360774817 | (37.7829193814773, -122.44360774817) | 15 | 5 | 1 | 29490 | 31 | |||
53638 | 138239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | 15 | 6 | 1 | 29490 | 31 | |||
53679 | 56848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 6x5 | Permit Number 14082 | 5998817.86133668 | 2106377.94605096 | 37.7636440271414 | -122.447272227776 | (37.7636440271414, -122.447272227776) | 15 | 5 | 11 | 29492 | 9 | ||
54510 | 225090 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002851.63466 | 2107200.77986 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | 15 | 5 | 5 | 28862 | 3 | |||
56518 | 237914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 5997227 | 2107052 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | 15 | 5 | 11 | 29492 | 12 | |||
56818 | 139055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.7845641202108 | -122.444654378813 | (37.7845641202108, -122.444654378813) | 15 | 6 | 11 | 29490 | 31 | |||
57765 | 225058 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996870.76469 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | 15 | 5 | 11 | 29492 | 12 | |||
62764 | 16626 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | 15 | 5 | 5 | 28862 | 3 | ||
62929 | 57320 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | 15 | 6 | 1 | 29490 | 31 | ||
63547 | 57317 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.445093871748 | (37.7846624482509, -122.445093871748) | 15 | 6 | 1 | 29490 | 31 | ||
66656 | 16644 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002849.24717 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | 15 | 5 | 5 | 28862 | 3 | |||
67860 | 57316 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | 15 | 6 | 1 | 29490 | 31 | ||
69587 | 67184 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30631 | 5998760.11857013 | 2106856.81248154 | 37.7649555743728 | -122.447506412542 | (37.7649555743728, -122.447506412542) | 15 | 5 | 11 | 29492 | 9 | ||
74388 | 16650 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | 15 | 5 | 5 | 28862 | 3 | |||
82931 | 110183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
89492 | 63739 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 665 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1988 12:00:00 AM | Permit Number 24410 | 6003393.73641512 | 2109629.91106527 | 37.7728335359212 | -122.431677907074 | (37.7728335359212, -122.431677907074) | 15 | 9 | 11 | 29492 | 10 | ||
93446 | 67186 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 281 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30634 | 5996869.12207945 | 2106987.0610707 | 37.7652049569046 | -122.454056265196 | (37.7652049569046, -122.454056265196) | 15 | 5 | 11 | 29492 | 12 | ||
95691 | 225059 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | 15 | 5 | 11 | 29492 | 12 | |||
104983 | 244452 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | 15 | 9 | 11 | 29492 | 10 | |||
107743 | 54886 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.451021722872 | (37.7657366841835, -122.451021722872) | 15 | 5 | 11 | 29492 | 9 | ||
108284 | 225093 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283 | -122.434083007749 | (37.770617436283, -122.434083007749) | 15 | 5 | 5 | 29492 | 9 | |||
110010 | 222924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998822.08068 | 2106365.67219 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | 15 | 5 | 11 | 29492 | 9 | |||
111120 | 225061 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5997502.5049 | 2105021.09629 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | 15 | 5 | 11 | 29492 | 12 | |||
111673 | 222927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998760.52748 | 2106841.60616 | 37.764913845009 | -122.44750390358 | (37.764913845009, -122.44750390358) | 15 | 5 | 11 | 29492 | 9 | |||
112170 | 56845 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | 15 | 5 | 11 | 29492 | 9 | ||
113085 | 58721 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19065 | 6002629.53182761 | 2108749.25499909 | 37.7703721248343 | -122.434258404788 | (37.7703721248343, -122.434258404788) | 15 | 5 | 5 | 29492 | 9 | |||
113408 | 139006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | 15 | 6 | 1 | 29490 | 31 | |||
115453 | 222918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997702.83236 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | 15 | 5 | 11 | 29492 | 9 | |||
118207 | 225062 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998883.5307 | 2107364.06639 | 37.7663554177878 | -122.447116070946 | (37.7663554177878, -122.447116070946) | 15 | 5 | 11 | 29492 | 9 | |||
124058 | 225092 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002638.75231 | 2108633.09345 | 37.7700536971488 | -122.434218205527 | (37.7700536971488, -122.434218205527) | 15 | 5 | 5 | 29492 | 9 | |||
132144 | 222926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998842.04298 | 2106555.36385 | 37.7641325536076 | -122.447201360861 | (37.7641325536076, -122.447201360861) | 15 | 5 | 11 | 29492 | 9 | |||
133710 | 222919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.7656625378249 | -122.450569558437 | (37.7656625378249, -122.450569558437) | 15 | 5 | 11 | 29492 | 9 | |||
134226 | 16641 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002897.9493228 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | 15 | 5 | 5 | 28862 | 3 | |||
134432 | 32473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.91054 | 2106227.11632 | 37.7633124078752 | -122.442259981907 | (37.7633124078752, -122.442259981907) | 15 | 5 | 5 | 28862 | 3 | |
139016 | 140578 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.7784358543561 | -122.431812198827 | (37.7784358543561, -122.431812198827) | 15 | 9 | 11 | 29492 | 41 | |||
146708 | 116858 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002788 | 2107242 | 37.7662425648461 | -122.433602528192 | (37.7662425648461, -122.433602528192) | 15 | 5 | 5 | 28862 | 3 | |||
156383 | 30908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1511 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34730 | 5999634.2212 | 2114153.2322 | 37.7850395970423 | -122.445007693392 | (37.7850395970423, -122.445007693392) | 15 | 6 | 1 | 29490 | 31 | ||
164599 | 51670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.447690414133 | (37.765863591183, -122.447690414133) | 15 | 5 | 11 | 29492 | 9 | ||||
169680 | 225063 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998979.47876 | 2106681.18548 | 37.7644858801306 | -122.44673506599 | (37.7644858801306, -122.44673506599) | 15 | 5 | 11 | 29492 | 9 | |||
170663 | 225064 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998981.07779 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | 15 | 5 | 11 | 29492 | 9 | |||
172639 | 56842 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 910 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | 3 | Permit Number 30536 | 5998759.08975741 | 2106864.1829233 | 37.7649757529568 | -122.447510501506 | (37.7649757529568, -122.447510501506) | 15 | 5 | 11 | 29492 | 9 | |
172953 | 34010 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.433283380019 | (37.7670985064042, -122.433283380019) | 15 | 5 | 5 | 28862 | 3 | |||
176339 | 244469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 665 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003415.8306 | 2109638.093 | 37.7728572538387 | -122.431602065027 | (37.7728572538387, -122.431602065027) | 15 | 9 | 11 | 29492 | 10 | |||
177221 | 61796 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 60 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21819 | 6002883.06164476 | 2108748.24537279 | 37.7703837393735 | -122.433381373664 | (37.7703837393735, -122.433381373664) | 15 | 5 | 5 | 29492 | 9 | ||
177869 | 33711 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | 15 | 9 | 11 | 29492 | 10 | |||
181866 | 68375 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.7629931985038 | -122.45048498279 | (37.7629931985038, -122.45048498279) | 15 | 5 | 11 | 29492 | 9 |
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) );