189 rows where Zip Codes = 29490 and qSpecies_id = 53 sorted by Supervisor Districts

View and edit SQL

Zip Codes

  • 29490 · 89
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)
93727 26951 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 10 Sidewalk: Curb side : Cutout Tree DPW 1     17 5x6   6002681.79801 2114441.89018 37.7860056439611 -122.434484700269 (37.7860056439611, -122.434484700269) 13 9 11 29490 27
93831 7281 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1820X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6003034.84406 2114579.8244 37.7864044107242 -122.433273117504 (37.7864044107242, -122.433273117504) 13 9 11 29490 27
94054 21691 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003627.3299403 2114521.0871369 37.7862767266181 -122.431219072895 (37.7862767266181, -122.431219072895) 13 9 11 29490 13
94472 20162 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1150X Steiner St 5 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4X4   6002889.114145 2112192.180758 37.7798402749908 -122.433606604391 (37.7798402749908, -122.433606604391) 15 9 11 29490 41
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
99392 94300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     6x6   6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
100106 7244 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1700 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 4x4   6003093.09301 2114182.05294 37.785315535228 -122.433043161197 (37.785315535228, -122.433043161197) 13 9 11 29490 13
100259 7260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
101481 7279 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1803 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6x6   6002990.14459 2114551.19489 37.7863232654697 -122.43342571959 (37.7863232654697, -122.43342571959) 13 9 11 29490 27
102040 7235 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1055 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003361.88401 2111924.41801 37.7791318785406 -122.431951960454 (37.7791318785406, -122.431951960454) 15 9 11 29490 41
104550 21748 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002560.9316389 2114541.9034523 37.786273393243 -122.434910019678 (37.786273393243, -122.434910019678) 13 9 11 29490 27
105043 6286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1480 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003841.85446 2113208.69765 37.7826853888603 -122.430383202835 (37.7826853888603, -122.430383202835) 7 9 11 29490 41
106831 7272 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003036.70673 2114326.97944 37.78571026818 -122.433248599687 (37.78571026818, -122.433248599687) 13 9 11 29490 13
108160 14847 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1336 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002770.69391 2111673.82369 37.7784102764476 -122.433979208741 (37.7784102764476, -122.433979208741) 15 5 11 29490 41
109108 21697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1890 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6003576.7245218 2114564.5327129 37.7863931493079 -122.431397256992 (37.7863931493079, -122.431397256992) 13 9 11 29490 27
109336 6287 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1480 Ellis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003811.10608 2113208.12243 37.7826820676681 -122.430489538043 (37.7826820676681, -122.430489538043) 7 9 11 29490 41
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
110637 7234 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1035 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003369.22487 2111874.56942 37.7789954228838 -122.431923005031 (37.7789954228838, -122.431923005031) 15 9 11 29490 41
110927 10713 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6003918.21533 2113256.44585 37.7828208186367 -122.430122434181 (37.7828208186367, -122.430122434181) 7 9 11 29490 41
112012 2718 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2185X Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6003092.7695 2114646.14799 37.786589804405 -122.433077450713 (37.786589804405, -122.433077450713) 13 9 11 29490 27
112969 21752 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1787X Steiner St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002537.7996519 2114344.6571005 37.7857304915222 -122.434975938446 (37.7857304915222, -122.434975938446) 13 9 11 29490 13
113644 22714 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 10 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
119421 7274 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002992.2982 2114509.63366 37.7862092710508 -122.433415297593 (37.7862092710508, -122.433415297593) 13 9 11 29490 27
119516 23795 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1119 Webster St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003757.7161484 2112550.5292093 37.7808734562577 -122.430627305455 (37.7808734562577, -122.430627305455) 15 9 11 29490 41
119793 7270 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     17 4X4   6003016.86176 2114375.85752 37.7858433492106 -122.433320751484 (37.7858433492106, -122.433320751484) 13 9 11 29490 13
120409 7217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
120524 9575 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003461.41634 2112120.31079 37.7796753933958 -122.431621626992 (37.7796753933958, -122.431621626992) 15 9 11 29490 41
121069 17729 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1300X Pierce St 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     60 3X3   6002290.56024 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321) 15 5 11 29490 41
121115 94298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
121492 7292 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1895X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002963.99476 2114778.43194 37.7869457171278 -122.433532436565 (37.7869457171278, -122.433532436565) 13 9 11 29490 27
121725 22672 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1115X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6003756.1555 2112617.12958 37.7810562358648 -122.430637458337 (37.7810562358648, -122.430637458337) 15 9 11 29490 41
121871 7220 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
121972 7230 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1040 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003407.87597 2111884.23201 37.7790241450036 -122.431789985507 (37.7790241450036, -122.431789985507) 15 9 11 29490 41
123574 21750 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840X Steiner St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002560.9316389 2114541.9034523 37.786273393243 -122.434910019678 (37.786273393243, -122.434910019678) 13 9 11 29490 27
130650 7226 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1025 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003385.45092 2111827.8386 37.7788680315263 -122.431863535021 (37.7788680315263, -122.431863535021) 15 9 11 29490 41
131361 21679 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1809 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003858.3353 2114554.3239 37.7863810745889 -122.430422226637 (37.7863810745889, -122.430422226637) 13 9 11 29490 13
133119 7231 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1040 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003407.87597 2111884.23201 37.7790241450036 -122.431789985507 (37.7790241450036, -122.431789985507) 15 9 11 29490 41
133383 7216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
134469 17726 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1300X Pierce St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     50 3X3   6002290.56024 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321) 15 5 11 29490 41
136831 7225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1015 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6003380.095 2111793.84702 37.7787743954893 -122.431879635495 (37.7787743954893, -122.431879635495) 15 9 11 29490 41
137509 22674 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003597.67072 2112512.14537 37.78075899563 -122.431178240155 (37.78075899563, -122.431178240155) 15 9 11 29490 41
139533 26952 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 11 Sidewalk: Curb side : Cutout Tree DPW 1     20 5x6   6002662.57908 2114440.54738 37.7860008659914 -122.434551096425 (37.7860008659914, -122.434551096425) 13 9 11 29490 27
140240 7269 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003018.18645 2114357.73087 37.7857936531706 -122.433314872696 (37.7857936531706, -122.433314872696) 13 9 11 29490 13
141056 121371 Undocumented 4 Ficus nitida :: Laurel Fig 53 11x Seymour St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001614 2112138 37.7796190766925 -122.438013896478 (37.7796190766925, -122.438013896478) 15 5 11 29490 41
142275 22700 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1390 Turk St 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6003367.49805 2112454.4444 37.7805875170515 -122.431970396947 (37.7805875170515, -122.431970396947) 15 9 11 29490 41
144803 7239 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1085 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003353.76677 2111995.41321 37.7793263534941 -122.431985112237 (37.7793263534941, -122.431985112237) 15 9 11 29490 41
145803 7268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003036.70673 2114326.97944 37.78571026818 -122.433248599687 (37.78571026818, -122.433248599687) 13 9 11 29490 13
147215 121369 Undocumented 4 Ficus nitida :: Laurel Fig 53 11x Seymour St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001614 2112138 37.7796190766925 -122.438013896478 (37.7796190766925, -122.438013896478) 15 5 11 29490 41
147266 26947 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002779.24505 2114452.89969 37.786041404384 -122.434148347649 (37.786041404384, -122.434148347649) 13 9 11 29490 27
148416 26945 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002804.14495 2114458.42232 37.7860579812909 -122.434062595727 (37.7860579812909, -122.434062595727) 13 9 11 29490 27
148675 7262 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
149790 22717 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 7 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
150893 17691 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1095X Pierce St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6002343.2153394 2112268.6379219 37.7800192180629 -122.435500577793 (37.7800192180629, -122.435500577793) 15 5 11 29490 41
151636 20239 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1757X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002551.4219946 2114246.4002369 37.7854614766008 -122.434921779618 (37.7854614766008, -122.434921779618) 13 9 11 29490 13
151746 10712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003917.66999 2113282.5787 37.7828925420276 -122.430126185708 (37.7828925420276, -122.430126185708) 7 9 11 29490 41
153353 7273 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002991.82699 2114526.90059 37.7862566549301 -122.433418162207 (37.7862566549301, -122.433418162207) 13 9 11 29490 27
154378 26949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 8 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6002710.37506 2114446.07693 37.7860187618492 -122.434386130989 (37.7860187618492, -122.434386130989) 13 9 11 29490 27
155152 26943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 5x6   6002846.96094 2114462.84733 37.7860725610737 -122.43391478048 (37.7860725610737, -122.43391478048) 13 9 11 29490 27
155245 7236 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1065 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003355.08756 2111967.13899 37.7792487944095 -122.431978523544 (37.7792487944095, -122.431978523544) 15 9 11 29490 41
155645 110676 Undocumented 4 Ficus nitida :: Laurel Fig 53 1898 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001594 2114879 37.7871440264162 -122.438279504546 (37.7871440264162, -122.438279504546) 13 6 11 29490 27
156308 7284 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6003030.41064 2114610.94925 37.7864896201648 -122.433290680867 (37.7864896201648, -122.433290680867) 13 9 11 29490 27
156870 21690 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003627.3299403 2114521.0871369 37.7862767266181 -122.431219072895 (37.7862767266181, -122.431219072895) 13 9 11 29490 13
159266 7227 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1025 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003385.45092 2111827.8386 37.7788680315263 -122.431863535021 (37.7788680315263, -122.431863535021) 15 9 11 29490 41
161493 6285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1480 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   6003867.05631 2113210.81806 37.7826926384963 -122.43029616652 (37.7826926384963, -122.43029616652) 7 9 11 29490 41
162853 105343 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2500X Post St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999969.06573 2113691.86409 37.7837919048286 -122.443816082596 (37.7837919048286, -122.443816082596) 15 6 11 29490 31
163074 110027 Undocumented 4 Ficus nitida :: Laurel Fig 53 1101X WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003707 2112516 37.7807757743573 -122.430800292528 (37.7807757743573, -122.430800292528) 15 9 11 29490 41
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
165652 21672 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1781 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004087.4531427 2114585.0546301 37.7864784293602 -122.429631729681 (37.7864784293602, -122.429631729681) 13 9 11 29490 13
166398 9620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1165X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1990 12:00:00 AM 50 3X3   6002862.99505 2112096.1743 37.779575183286 -122.433690098242 (37.779575183286, -122.433690098242) 15 9 11 29490 41
171101 17693 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1095X Pierce St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6002343.2153394 2112268.6379219 37.7800192180629 -122.435500577793 (37.7800192180629, -122.435500577793) 15 5 11 29490 41
172861 117048 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2183 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002170 2114323 37.7856501363162 -122.436246868292 (37.7856501363162, -122.436246868292) 13 6 11 29490 13
174162 16730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003888.91549 2113509.70556 37.7835145469728 -122.430241873385 (37.7835145469728, -122.430241873385) 7 9 11 29490 41
174828 21667 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1773 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004123.7222039 2114590.0968475 37.7864943276059 -122.429506607504 (37.7864943276059, -122.429506607504) 13 9 11 29490 13
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
181230 7271 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003011.13827 2114398.62455 37.7859055370085 -122.433342180608 (37.7859055370085, -122.433342180608) 13 9 11 29490 13
181893 7246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1700 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6003087.664 2114207.65389 37.7853855210138 -122.433063773672 (37.7853855210138, -122.433063773672) 13 9 11 29490 13
182329 21698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1890 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6003576.7245218 2114564.5327129 37.7863931493079 -122.431397256992 (37.7863931493079, -122.431397256992) 13 9 11 29490 27
183127 7232 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003365.392 2111902.08022 37.7790707434033 -122.431938229416 (37.7790707434033, -122.431938229416) 15 9 11 29490 41
184850 2719 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2185X Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003092.7695 2114646.14799 37.786589804405 -122.433077450713 (37.786589804405, -122.433077450713) 13 9 11 29490 27
187443 22718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 6 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
187860 22712 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 12 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
188273 2450 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1805X Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6003959.520066 2114567.2690482 37.7864223498862 -122.430073076908 (37.7864223498862, -122.430073076908) 13 9 11 29490 13
189695 21726 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1942 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003284.347 2114523.85502 37.7862648839776 -122.432405902047 (37.7862648839776, -122.432405902047) 13 9 11 29490 27
190566 21751 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1787X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002537.7996519 2114344.6571005 37.7857304915222 -122.434975938446 (37.7857304915222, -122.434975938446) 13 9 11 29490 13
190628 7233 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003367.24511 2111893.72513 37.7790479074603 -122.431931222001 (37.7790479074603, -122.431931222001) 15 9 11 29490 41
193568 26953 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 12 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002643.91242 2114436.71459 37.7859892824562 -122.43461540376 (37.7859892824562, -122.43461540376) 13 9 11 29490 27
193625 255507 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41

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