177 rows where Supervisor Districts = 11 and qSpecies_id = 95 sorted by Neighborhoods (old)

View and edit SQL

Supervisor 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) ▼
109533 61327 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1939 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21230 5999877.32388758 2111224.65022553 37.7770123365346 -122.443956146179 (37.7770123365346, -122.443956146179) 15 5 11 29492 16
114831 61328 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1945 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21231 5999849.86914689 2111220.88656755 37.7770004363515 -122.444050849823 (37.7770004363515, -122.444050849823) 15 5 11 29492 16
115167 63674 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 911 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1987 12:00:00 AM     Permit Number 24326 5999505.51324752 2111590.21998339 37.7779948811468 -122.445268639971 (37.7779948811468, -122.445268639971) 15 5 11 54 16
142369 69300 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1680 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1994 12:00:00 AM     Permit Number 33375 5999724.98067163 2110906.29768043 37.7761295304752 -122.444460261753 (37.7761295304752, -122.444460261753) 15 5 11 29492 16
143084 137698 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 726 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000067.2767 2111422.2746 37.7775657963039 -122.443313240617 (37.7775657963039, -122.443313240617) 15 5 11 29490 16
159370 27856 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 350 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   5999054.4459 2111673.3239 37.7781973051578 -122.446835017559 (37.7781973051578, -122.446835017559) 15 5 11 54 16
109965 138055 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1801 Webster St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6003429.2071 2114921.0289 37.787363636105 -122.431933094738 (37.787363636105, -122.431933094738) 13 9 11 29490 27
123077 2683 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2100 Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003416.3801 2114894.2482 37.7872893759097 -122.431975560402 (37.7872893759097, -122.431975560402) 13 9 11 29490 27
183655 138053 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1801 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003423.5383 2114956.5878 37.7874609504744 -122.43195524769 (37.7874609504744, -122.43195524769) 13 9 11 29490 27
1591 2218 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000845.8161 2112827.2327 37.7814678183412 -122.440720821523 (37.7814678183412, -122.440720821523) 15 5 11 29490 41
15782 62812 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1574 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23173 6002055.59325956 2111926.02804276 37.7790621580208 -122.436471061747 (37.7790621580208, -122.436471061747) 15 5 11 29490 41
24186 62951 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1795 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23833 6002734.78397825 2113355.91233134 37.7830268313176 -122.434223718554 (37.7830268313176, -122.434223718554) 15 9 11 29490 41
36478 62820 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1666 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23181 6001608.96718094 2111863.71971142 37.7788656861573 -122.438011654973 (37.7788656861573, -122.438011654973) 15 5 11 29490 41
43483 63273 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2049 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23832 6001545.00229536 2113189.36055962 37.7825019218083 -122.438327931003 (37.7825019218083, -122.438327931003) 15 5 11 29490 41
46432 62824 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1484 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23185 6002057.23987629 2111579.51658727 37.7781108182995 -122.436440558232 (37.7781108182995, -122.436440558232) 15 5 11 29490 41
51215 139636 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 932 BRODERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000950.5576 2112049.201 37.7793375058125 -122.440302654193 (37.7793375058125, -122.440302654193) 15 5 11 29490 41
52690 2182 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1008 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4X4   6000953.66092 2112196.05676 37.7797409110638 -122.440302453138 (37.7797409110638, -122.440302453138) 15 5 11 29490 41
54312 2222 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6000826.6953 2112946.8648 37.7817952085876 -122.440795554247 (37.7817952085876, -122.440795554247) 15 5 11 29490 41
63369 67474 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1658 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 30996 6001647.35172607 2111869.10246706 37.778882648645 -122.437879253527 (37.778882648645, -122.437879253527) 15 5 11 29490 41
64222 63848 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1483 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24545 6002073.44175228 2111529.25048836 37.7779737208393 -122.436380911725 (37.7779737208393, -122.436380911725) 15 5 11 29492 41
69000 6370 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2090X Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6000874.84598 2112802.06696 37.7814003728012 -122.440618586812 (37.7814003728012, -122.440618586812) 15 5 11 29490 41
74853 62807 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1502 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23166 6002384.65148125 2111971.31576177 37.779205199431 -122.435335957918 (37.779205199431, -122.435335957918) 15 5 11 29490 41
78079 139493 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 800 DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001570.1034 2111181.7117 37.7769908539916 -122.438097232435 (37.7769908539916, -122.438097232435) 15 5 11 29492 41
80480 139651 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1002 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000935.1594 2112168.6639 37.7796646438253 -122.440364492738 (37.7796646438253, -122.440364492738) 15 5 11 29490 41
80681 62843 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1601 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1989 12:00:00 AM     Permit Number 23211 6002354.90131864 2112261.69493226 37.7800008180577 -122.435459653978 (37.7800008180577, -122.435459653978) 15 5 11 29490 41
81786 62808 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1512 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23167 6002338.94894868 2111965.02580055 37.7791853332214 -122.435493611495 (37.7791853332214, -122.435493611495) 15 5 11 29490 41
85649 2235 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1250 Broderick St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6000835.53681 2113039.07181 37.7820488889703 -122.44077158306 (37.7820488889703, -122.44077158306) 15 5 11 29490 41
89783 62806 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 998 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23165 6001478.75963757 2111822.72775324 37.7787457270266 -122.438459155796 (37.7787457270266, -122.438459155796) 15 5 11 29490 41
100565 62810 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1525 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23169 6002291.19574919 2111905.96343964 37.7790204505777 -122.435654582558 (37.7790204505777, -122.435654582558) 15 5 11 29490 41
103833 2221 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000832.11 2112918.4374 37.7817174625844 -122.44077478218 (37.7817174625844, -122.44077478218) 15 5 11 29490 41
119091 67481 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1598 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 31004 6001509.57860385 2111503.53144301 37.777871047567 -122.438329667297 (37.777871047567, -122.438329667297) 15 5 11 29490 41
122595 2220 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6000834.479 2112894.4094 37.7816516227539 -122.440764862478 (37.7816516227539, -122.440764862478) 15 5 11 29490 41
128239 63190 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1940 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM     Permit Number 23729 6001603.1859091 2112901.47419307 37.7817147682428 -122.438106012539 (37.7817147682428, -122.438106012539) 15 5 11 29490 41
130319 62809 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1521 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23168 6002309.47676222 2111908.47942413 37.7790283971732 -122.435591521295 (37.7790283971732, -122.435591521295) 15 5 11 29490 41
131737 63271 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1800 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23830 6001386.26443426 2112180.71364321 37.7797234038821 -122.438804791999 (37.7797234038821, -122.438804791999) 15 5 11 29490 41
132618 60496 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1321 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1982 12:00:00 AM     Permit Number 20094 6001757.67360022 2112974.28718106 37.7819234789346 -122.437576774938 (37.7819234789346, -122.437576774938) 15 5 11 29490 41
138178 2224 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1200X Broderick St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000821.2805 2112988.1523 37.7819082651248 -122.440817249491 (37.7819082651248, -122.440817249491) 15 5 11 29490 41
149703 139652 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1004 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000931.7752 2112195.3992 37.7797378594663 -122.440378118045 (37.7797378594663, -122.440378118045) 15 5 11 29490 41
155916 139548 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2086 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000870.6055 2112799.3975 37.7813928016707 -122.440633065246 (37.7813928016707, -122.440633065246) 15 5 11 29490 41
156894 5232 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1060 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6001447.2358 2112106.5793 37.7795233183444 -122.43858855259 (37.7795233183444, -122.43858855259) 15 5 11 29490 41
157594 63187 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2043 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23726 6001104.49990341 2112782.16109976 37.7813587913625 -122.439822670066 (37.7813587913625, -122.439822670066) 15 5 11 29490 41
166459 2181 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1006 Broderick St 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6000928.0526 2112222.8113 37.7798129141573 -122.440392962604 (37.7798129141573, -122.440392962604) 15 5 11 29490 41
172794 62840 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3 Seymour St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1986 12:00:00 AM     Permit Number 23207 6001668.62546357 2111862.95878807 37.7788669893558 -122.437805219223 (37.7788669893558, -122.437805219223) 15 5 11 29490 41
179896 63641 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 701 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31106 6001035.54169923 2111072.80974441 37.7766614211292 -122.43993863172 (37.7766614211292, -122.43993863172) 15 5 11 29492 41
194007 22791 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1008X Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6000922.6378 2112256.3151 37.7799045987504 -122.44041409826 (37.7799045987504, -122.44041409826) 15 5 11 29490 41
62472 67728 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 516 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31347 5997107.4486428 2107419.61483204 37.7664063016043 -122.453263185466 (37.7664063016043, -122.453263185466) 15 5 11 29492 8
2120 262362 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 160 Central Ave 2 Sidewalk: Property side : Cutout Tree Private 2       Width 0ft   5999920 2109126 37.7712524099727 -122.443657715912 (37.7712524099727, -122.443657715912) 15 5 11 29492 9
2437 221745 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 200 Grattan St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5997627.57278 2106480.28137 37.7638569284848 -122.451396424803 (37.7638569284848, -122.451396424803) 15 5 11 29492 9
3279 262361 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 160 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5999920 2109126 37.7712524099727 -122.443657715912 (37.7712524099727, -122.443657715912) 15 5 11 29492 9
12127 225284 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 101 Rivoli St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998165.49077 2105960.31713 37.7624600250279 -122.449498469484 (37.7624600250279, -122.449498469484) 15 5 11 29492 9
25693 10445 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1509 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 2X3   5998900.22539 2108626.72926 37.76982332449 -122.447149207323 (37.76982332449, -122.447149207323) 15 5 11 29492 9
27194 245173 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1456 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5999636.4444 2109155.2635 37.7713165836595 -122.44464064682 (37.7713165836595, -122.44464064682) 15 5 11 29492 9
29218 63761 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 343 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24438 6003220.73981685 2109435.30524559 37.7722893887759 -122.43226242096 (37.7722893887759, -122.43226242096) 15 9 11 29492 9
40231 244084 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 410 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997482.1156 2109015.099 37.7708085597069 -122.452082413717 (37.7708085597069, -122.452082413717) 15 5 11 29492 9
42700 225281 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 101 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998106.32267 2105949.33656 37.7624264902133 -122.44970231793 (37.7624264902133, -122.44970231793) 15 5 11 29492 9
52347 244532 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1520 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5998840.1845 2108701.1538 37.7700242446482 -122.447362243956 (37.7700242446482, -122.447362243956) 15 5 11 29492 9
54726 58595 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 125 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1992 12:00:00 AM     Permit Number 30451 5998119.2058649 2105940.33836746 37.762402520504 -122.449657111476 (37.762402520504, -122.449657111476) 15 5 11 29492 9
66653 63766 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 401 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24444 6003192.52222029 2109638.52781799 37.7728457879591 -122.432374545195 (37.7728457879591, -122.432374545195) 15 9 11 29492 9
67342 10380 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1317 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1991 12:00:00 AM 20 3X3   5999820.7705 2108786.6551 37.7703149945231 -122.443976567638 (37.7703149945231, -122.443976567638) 15 5 11 29492 9
70800 225282 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 101 Rivoli St 2 Sidewalk: Curb side : Cutout Landscaping Private 2     6 Width 3ft   5998123.1152 2105954.07554 37.762440462975 -122.44964458054 (37.762440462975, -122.44964458054) 15 5 11 29492 9
71194 10383 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1327 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5999833.28029 2108766.34053 37.7702599294313 -122.443931836642 (37.7702599294313, -122.443931836642) 15 5 11 29492 9
102386 66753 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1077 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/12/1991 12:00:00 AM     Permit Number 30005 5998848.66336844 2106157.27951902 37.7630398921609 -122.447149811738 (37.7630398921609, -122.447149811738) 15 5 11 29492 9
104176 246009 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1509 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998901.8356 2108659.6183 37.7699137214477 -122.447146004959 (37.7699137214477, -122.447146004959) 15 5 11 29492 9
108504 63758 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 425 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24434 6003181.69109256 2109716.53339488 37.7730593578892 -122.432417583748 (37.7730593578892, -122.432417583748) 15 9 11 29492 9
119117 63752 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 722 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24425 6003101.35751437 2109641.71994707 37.772849383001 -122.432690122287 (37.772849383001, -122.432690122287) 15 5 11 29492 9
120630 63764 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 311 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24442 6003235.24732503 2109330.82245921 37.7720033272962 -122.4322047752 (37.7720033272962, -122.4322047752) 15 9 11 29492 9
129504 233525 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 144 Grattan St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5997911.36831 2106517.58465 37.7639756003107 -122.450417555923 (37.7639756003107, -122.450417555923) 15 5 11 29492 9
140254 233526 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 22 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5998549.32409 2106920.03267 37.7651171124773 -122.448240047256 (37.7651171124773, -122.448240047256) 15 5 11 29492 9
161739 10346 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 959 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6001539.009 2109027.09783 37.7710730553048 -122.438050421808 (37.7710730553048, -122.438050421808) 15 5 11 29492 9
166127 233524 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 144 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5997927.77763 2106520.29588 37.7639839837988 -122.450360996685 (37.7639839837988, -122.450360996685) 15 5 11 29492 9
166868 10321 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6002536.32245 2109085.56364 37.7712902545388 -122.434604866834 (37.7712902545388, -122.434604866834) 15 5 11 29492 9
168128 63755 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 832 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24429 6002579.84478406 2109569.92728925 37.7726226680298 -122.434488959034 (37.7726226680298, -122.434488959034) 15 5 11 29492 9
169471 10350 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 981 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001468.92612 2109016.3918 37.7710396733632 -122.438292073219 (37.7710396733632, -122.438292073219) 15 5 11 29492 9
180227 10333 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 849 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6002068.30214 2109102.87346 37.7713112029881 -122.436225005803 (37.7713112029881, -122.436225005803) 15 5 11 29492 9
186526 233510 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 757 Haight St 2 : Tree Private 2     10 Width 3ft   6002532.75447 2109164.64815 37.7715071985232 -122.434622864475 (37.7715071985232, -122.434622864475) 15 5 11 29492 9
186970 225283 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 101 Rivoli St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998142.22071 2105955.37376 37.7624451205691 -122.449578595475 (37.7624451205691, -122.449578595475) 15 5 11 29492 9
193819 62622 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 183 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1986 12:00:00 AM     Permit Number 22936 5997384.53937268 2107058.88452992 37.7654317060994 -122.452278752633 (37.7654317060994, -122.452278752633) 15 5 11 29492 9

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