81 rows where Fire Prevention Districts = 15 and qSpecies_id = 5 sorted by Longitude

View and edit SQL

Fire Prevention Districts

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)
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
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
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
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
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
108294 140580 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003403.4849 2111618.6108 37.7782945663272 -122.43178620552 (37.7782945663272, -122.43178620552) 15 9 11 29492 41
57482 140579 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003399.7999 2111643.4846 37.7783626547096 -122.431800729752 (37.7783626547096, -122.431800729752) 15 9 11 29492 41
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
24686 20125 Permitted Site 7 Ceratonia siliqua :: Carob 5 924X Fell St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002999.41967 2110319.25168 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251) 15 5 11 29492 10
106329 142100 DPW Maintained 1 Ceratonia siliqua :: Carob 5 904 Fell St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6002972.7027 2110318.8393 37.7747012881718 -122.433183544102 (37.7747012881718, -122.433183544102) 15 5 11 29492 10
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
111478 139056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
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
61904 110184 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
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
82972 110185 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
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
179176 139007 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999691.7088 2114071.461 37.7848183554363 -122.444802925313 (37.7848183554363, -122.444802925313) 15 6 1 29490 31
156051 139008 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999687.2486 2114098.7181 37.7848929418184 -122.444820316061 (37.7848929418184, -122.444820316061) 15 6 1 29490 31
116533 138243 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5999648.5931 2114056.0979 37.7847737117432 -122.444950986247 (37.7847737117432, -122.444950986247) 15 6 1 29490 31
68552 138242 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999647.1063 2114070.9654 37.7848144491807 -122.444957199215 (37.7848144491807, -122.444957199215) 15 6 1 29490 31
75012 138241 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999646.1152 2114082.8594 37.7848470504501 -122.444961483404 (37.7848470504501, -122.444961483404) 15 6 1 29490 31
97344 138240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243) 15 6 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
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
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
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
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
187922 10409 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5999436 2108778 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847) 15 5 11 29492 9
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
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
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
171993 225042 DPW Maintained 1 Ceratonia siliqua :: Carob 5 979 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999193.16537 2106656.55415 37.7644304531311 -122.445994213458 (37.7644304531311, -122.445994213458) 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
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
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
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
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
16559 222925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998825.08997 2106348.09575 37.7635624787486 -122.447245077795 (37.7635624787486, -122.447245077795) 15 5 11 29492 9
85587 94581 Permitted Site 7 Ceratonia siliqua :: Carob 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5998825 2106371 37.763625362932 -122.447247037522 (37.763625362932, -122.447247037522) 15 5 11 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
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
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
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
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
18852 222928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 912 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5998758.16977 2106859.07637 37.7649616790718 -122.447513315894 (37.7649616790718, -122.447513315894) 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
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
20659 59670 Permitted Site 7 Ceratonia siliqua :: Carob 5 98X PARNASSUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 15 3x3 Permit Number 32228 5998297 2106864 37.7649488326227 -122.449108733904 (37.7649488326227, -122.449108733904) 15 5 11 29492 9
145445 222923 DPW Maintained 1 Ceratonia siliqua :: Carob 5 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5998162.74598 2106870.63901 37.7649593821837 -122.449573561064 (37.7649593821837, -122.449573561064) 15 5 11 29492 9
69905 222921 DPW Maintained 1 Ceratonia siliqua :: Carob 5 957 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.449866104246 (37.7649946607859, -122.449866104246) 15 5 11 29492 9
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
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
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
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
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
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
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
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
25898 225060 DPW Maintained 1 Ceratonia siliqua :: Carob 5 243 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5997087.67897 2106671.87912 37.7643520771977 -122.453277577199 (37.7643520771977, -122.453277577199) 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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);