trees
151 rows where qSpecies_id = 185 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194390 | 8397 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.429761413143 | (37.7847401317276, -122.429761413143) | 13 | 9 | 11 | 29490 | 41 | |||
191950 | 201525 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 740 Earl St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | 6020363.02265 | 2093708.60357 | 37.7300640742831 | -122.371876721056 | (37.7300640742831, -122.371876721056) | 10 | 3 | 8 | 58 | 1 | ||||
191325 | 120634 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
190623 | 223691 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1407 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005889.20889 | 2100701.54166 | 37.7484594630387 | -122.422411257281 | (37.7484594630387, -122.422411257281) | 2 | 4 | 5 | 28859 | 19 | |||
188029 | 256520 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 2 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
187679 | 250188 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5997295.79437 | 2110912.47939 | 37.7760076003172 | -122.452863871972 | (37.7760076003172, -122.452863871972) | 15 | 6 | 2 | 29492 | 16 | ||||
187186 | 8402 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.7850570827926 | -122.428012143853 | (37.7850570827926, -122.428012143853) | 13 | 9 | 11 | 28858 | 13 | |||
186496 | 120632 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
184517 | 2278 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 12 | Median : Cutout | Tree | DPW 1 | 40 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
182713 | 251242 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
176953 | 8615 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2600 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 20 | 5999346.5229 | 2113229.024 | 37.7824855372935 | -122.445936539759 | (37.7824855372935, -122.445936539759) | 15 | 5 | 1 | 54 | 16 | |||
176827 | 190962 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Jack Balestreri Way | 34 | Front Yard : Yard | Tree | Private 2 | 22 | 6012415.27524 | 2104795.5991 | 37.7600668346491 | -122.400131588717 | (37.7600668346491, -122.400131588717) | 10 | 3 | 8 | 28856 | 29 | ||||
176172 | 250570 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5997272.19957 | 2111059.97973 | 37.7764112457195 | -122.452956141515 | (37.7764112457195, -122.452956141515) | 15 | 6 | 2 | 29492 | 16 | ||||
174432 | 223688 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 79 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6003610.63527 | 2095763.96292 | 37.7347732077997 | -122.429938363379 | (37.7347732077997, -122.429938363379) | 2 | 7 | 5 | 63 | 7 | ||||
173074 | 250568 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5997280.42003 | 2111005.26169 | 37.7762614753232 | -122.452923754242 | (37.7762614753232, -122.452923754242) | 15 | 6 | 2 | 29492 | 16 | ||||
172890 | 250576 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 8ft | 5997348.72093 | 2111207.04633 | 37.7768194372103 | -122.452702050664 | (37.7768194372103, -122.452702050664) | 15 | 6 | 2 | 29492 | 16 | |||
164301 | 250593 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 7ft | 5998409.0493 | 2111353.95011 | 37.7772834963756 | -122.449044657195 | (37.7772834963756, -122.449044657195) | 15 | 6 | 2 | 29492 | 16 | |||
162827 | 119449 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 895 32nd Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5986012.77354 | 2109822.77383 | 37.7723625508497 | -122.49181402136 | (37.7723625508497, -122.49181402136) | 11 | 6 | 2 | 55 | 26 | ||||
162203 | 250596 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 5998572.26922 | 2111378.38591 | 37.7773599243436 | -122.448481789509 | (37.7773599243436, -122.448481789509) | 15 | 6 | 2 | 29492 | 16 | |||
159576 | 19448 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400X Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5986974.9102614 | 2095954.0242956 | 37.7343389133904 | -122.48746699486 | (37.7343389133904, -122.48746699486) | 1 | 8 | 3 | 64 | 35 | |||
159138 | 19404 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 500X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5989983.811155 | 2096024.6780472 | 37.7347079305354 | -122.477069523101 | (37.7347079305354, -122.477069523101) | 1 | 8 | 3 | 64 | 35 | |||
157488 | 250598 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 10ft | 5998612.86839 | 2111383.01591 | 37.7773749583343 | -122.448341677839 | (37.7773749583343, -122.448341677839) | 15 | 6 | 2 | 29492 | 16 | |||
156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
154838 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 760 Victoria St | 5 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
154501 | 8654 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2800 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 18 | M6 | 5998424.6782121 | 2113209.2212936 | 37.7823784827906 | -122.449124279941 | (37.7823784827906, -122.449124279941) | 15 | 6 | 1 | 54 | 31 | |||
151398 | 8338 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
146313 | 250584 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997564.36038 | 2111236.37019 | 37.7769123065995 | -122.451958208801 | (37.7769123065995, -122.451958208801) | 15 | 6 | 2 | 29492 | 16 | ||||
145946 | 250585 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5997613.33684 | 2111244.7016 | 37.7769379876264 | -122.451789386298 | (37.7769379876264, -122.451789386298) | 15 | 6 | 2 | 29492 | 16 | |||
145293 | 250592 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 7ft | 5998381.46097 | 2111351.09812 | 37.7772740876697 | -122.44913988819 | (37.7772740876697, -122.44913988819) | 15 | 6 | 2 | 29492 | 16 | |||
145070 | 19450 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5986548.4544357 | 2095908.9031645 | 37.7341901424899 | -122.488938055092 | (37.7341901424899, -122.488938055092) | 1 | 8 | 3 | 64 | 35 | |||
144707 | 250586 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5997628.86615 | 2111246.4251 | 37.7769436093046 | -122.451735790285 | (37.7769436093046, -122.451735790285) | 15 | 6 | 2 | 29492 | 16 | |||
143676 | 247880 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 387 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6009937.12086 | 2098396.47956 | 37.742357783278 | -122.408251038648 | (37.742357783278, -122.408251038648) | 10 | 7 | 7 | 28859 | 2 | ||||
143099 | 250599 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998631.4294 | 2111385.56774 | 37.7773830261474 | -122.448277653315 | (37.7773830261474, -122.448277653315) | 15 | 6 | 2 | 29492 | 16 | |||
140301 | 117931 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 593 42nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5982837.98596 | 2111790.04502 | 37.777578036656 | -122.502941388113 | (37.777578036656, -122.502941388113) | 11 | 6 | 2 | 55 | 26 | |||
138786 | 255536 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
137346 | 119448 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 895 32nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5986011.64571 | 2109832.7311 | 37.7723898247803 | -122.491818655745 | (37.7723898247803, -122.491818655745) | 11 | 6 | 2 | 55 | 26 | ||||
135758 | 8618 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2600 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999321.4797 | 2113227.3319 | 37.7824794612004 | -122.446023056262 | (37.7824794612004, -122.446023056262) | 15 | 5 | 1 | 54 | 16 | |||
132031 | 120630 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
128564 | 19405 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 500X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5989983.811155 | 2096024.6780472 | 37.7347079305354 | -122.477069523101 | (37.7347079305354, -122.477069523101) | 1 | 8 | 3 | 64 | 35 | |||
126271 | 250572 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/15/2017 12:00:00 AM | 3 | Permit Number 779711 | 5997267.39343 | 2111112.94332 | 37.7765563945078 | -122.45297659119 | (37.7765563945078, -122.45297659119) | 15 | 6 | 2 | 29492 | 16 | ||
125281 | 21145 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2292X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
124598 | 8347 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
123945 | 8352 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 18 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
123197 | 19398 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 300X Sloat Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990549.2944822 | 2096013.3169503 | 37.7347095261344 | -122.475113645462 | (37.7347095261344, -122.475113645462) | 1 | 8 | 4 | 64 | 40 | |||
123027 | 120635 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
120229 | 122962 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 98 09th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5993057.14542 | 2114935.59748 | 37.7868101834412 | -122.467819022079 | (37.7868101834412, -122.467819022079) | 11 | 6 | 1 | 54 | 11 | |||
119779 | 249598 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 7ft | 5998888.01684 | 2111424.33867 | 37.7775041468442 | -122.447392828322 | (37.7775041468442, -122.447392828322) | 15 | 6 | 2 | 29492 | 16 | |||
117631 | 87565 | Permitted Site 7 | Cupressocyparis leylandii :: Leyland Cypress 185 | 10 Corwin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50392 | 6000837 | 2103986 | 37.7571914971866 | -122.440117143339 | (37.7571914971866, -122.440117143339) | 2 | 4 | 5 | 28862 | 38 | |||
117482 | 8656 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | M6 | 5998424.6782121 | 2113209.2212936 | 37.7823784827906 | -122.449124279941 | (37.7823784827906, -122.449124279941) | 15 | 6 | 1 | 54 | 31 | |||
114359 | 87566 | Permitted Site 7 | Cupressocyparis leylandii :: Leyland Cypress 185 | 10 Corwin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50392 | 6000837 | 2103986 | 37.7571914971866 | -122.440117143339 | (37.7571914971866, -122.440117143339) | 2 | 4 | 5 | 28862 | 38 | |||
113607 | 19438 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1302X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5987401.6755259 | 2095951.2124587 | 37.7343560725457 | -122.485991341651 | (37.7343560725457, -122.485991341651) | 1 | 8 | 3 | 64 | 35 | |||
109299 | 250595 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | 5998510.66659 | 2111373.95167 | 37.7773442266945 | -122.448694572711 | (37.7773442266945, -122.448694572711) | 15 | 6 | 2 | 29492 | 16 | ||||
105835 | 8403 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.7850570827926 | -122.428012143853 | (37.7850570827926, -122.428012143853) | 13 | 9 | 11 | 28858 | 13 | |||
103239 | 250573 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5997263.27261 | 2111141.17003 | 37.7766336615401 | -122.45299288421 | (37.7766336615401, -122.45299288421) | 15 | 6 | 2 | 29492 | 16 | ||||
100952 | 87567 | Permitted Site 7 | Cupressocyparis leylandii :: Leyland Cypress 185 | 10 Corwin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50392 | 6000837 | 2103986 | 37.7571914971866 | -122.440117143339 | (37.7571914971866, -122.440117143339) | 2 | 4 | 5 | 28862 | 38 | |||
99384 | 176093 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Italy Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 6002215.73545 | 2088910.66953 | 37.7158765144653 | -122.434271211548 | (37.7158765144653, -122.434271211548) | 9 | 7 | 6 | 28861 | 5 | |||
99268 | 250571 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5997270.54496 | 2111084.7365 | 37.7764791265377 | -122.452963652673 | (37.7764791265377, -122.452963652673) | 15 | 6 | 2 | 29492 | 16 | ||||
97731 | 251241 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2305 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998495 | 2111363 | 37.777313260379 | -122.448747979297 | (37.777313260379, -122.448747979297) | 15 | 6 | 2 | 29492 | 16 | |||||
97351 | 2279 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 13 | Median : Cutout | Tree | DPW 1 | 40 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
94259 | 250575 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5997256.45682 | 2111186.28266 | 37.7767571384568 | -122.453019719107 | (37.7767571384568, -122.453019719107) | 15 | 6 | 2 | 29492 | 16 | ||||
93897 | 250589 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5997875.41929 | 2111281.04875 | 37.7770527941865 | -122.450885388659 | (37.7770527941865, -122.450885388659) | 15 | 6 | 2 | 29492 | 16 | ||||
93179 | 223686 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6003580.53373 | 2095739.50976 | 37.734704360212 | -122.430040690922 | (37.734704360212, -122.430040690922) | 2 | 7 | 5 | 63 | 7 | ||||
90989 | 8343 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
86290 | 8335 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
86244 | 250580 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 5997493.10232 | 2111228.13721 | 37.7768856192175 | -122.452204116724 | (37.7768856192175, -122.452204116724) | 15 | 6 | 2 | 29492 | 16 | |||
86023 | 19397 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 300X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990549.2944822 | 2096013.3169503 | 37.7347095261344 | -122.475113645462 | (37.7347095261344, -122.475113645462) | 1 | 8 | 4 | 64 | 40 | |||
81963 | 8336 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
78510 | 256521 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 3 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
77635 | 250567 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 5997282.79592 | 2110980.7211 | 37.7761942294073 | -122.452913763658 | (37.7761942294073, -122.452913763658) | 15 | 6 | 2 | 29492 | 16 | ||||
76894 | 256873 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
76832 | 223689 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 278 Upper Ter | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | Width 4ft | 5999412.71789 | 2106090.89076 | 37.7628898173431 | -122.445194172985 | (37.7628898173431, -122.445194172985) | 15 | 5 | 5 | 29492 | 9 | |||
76163 | 19396 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 200X Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5990818.4331684 | 2096048.8602469 | 37.7348227139519 | -122.474185743261 | (37.7348227139519, -122.474185743261) | 1 | 8 | 4 | 29491 | 40 | |||
74907 | 30067 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
73363 | 8346 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
71202 | 250578 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 5997460.21338 | 2111222.95498 | 37.7768695060652 | -122.452317514945 | (37.7768695060652, -122.452317514945) | 15 | 6 | 2 | 29492 | 16 | |||
70206 | 250569 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 5997276.19674 | 2111033.33857 | 37.7763383251004 | -122.452940390794 | (37.7763383251004, -122.452940390794) | 15 | 6 | 2 | 29492 | 16 | ||||
66218 | 223690 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 3287 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006386.04454 | 2103750.12413 | 37.7568581848634 | -122.420909618783 | (37.7568581848634, -122.420909618783) | 2 | 4 | 7 | 28859 | 19 | |||
65742 | 176092 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Italy Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6002233.31845 | 2088899.94109 | 37.715848054527 | -122.434209670065 | (37.715848054527, -122.434209670065) | 9 | 7 | 6 | 28861 | 5 | |||
65239 | 249599 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 7ft | 5998912.4282 | 2111428.40333 | 37.7775167022821 | -122.447308674267 | (37.7775167022821, -122.447308674267) | 15 | 6 | 2 | 29492 | 16 | |||
63816 | 8345 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
62413 | 223687 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 San Jose Ave | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6003595.32282 | 2095749.76231 | 37.7347333489588 | -122.429990291123 | (37.7347333489588, -122.429990291123) | 2 | 7 | 5 | 63 | 7 | ||||
61863 | 190963 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Jack Balestreri Way | 35 | Front Yard : Yard | Tree | Private 2 | 28 | 6012430.01623 | 2104809.07988 | 37.7601046718029 | -122.400081553118 | (37.7601046718029, -122.400081553118) | 10 | 3 | 8 | 28856 | 29 | ||||
60066 | 8337 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
59450 | 2280 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 750X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 40 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
58528 | 19484 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 20M | 5984311.7495235 | 2095837.0474516 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | 1 | 8 | 3 | 64 | 35 | |||
58198 | 8538 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2100 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651 | (37.7837972495813, -122.43786449651) | 15 | 5 | 11 | 29490 | 13 | |||
54360 | 250577 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 8ft | 5997444.6396 | 2111219.72454 | 37.7768597439099 | -122.452371155927 | (37.7768597439099, -122.452371155927) | 15 | 6 | 2 | 29492 | 16 | |||
52424 | 176095 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 271 Leland Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009495.21066 | 2087687.13777 | 37.7129274396128 | -122.409023568 | (37.7129274396128, -122.409023568) | 9 | 7 | 8 | 309 | 39 | |||
51838 | 186505 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400 Lower Great Hwy | 5 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | 1 | 8 | 3 | 56 | 35 | |||
49824 | 250612 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 7ft | 5998863.03763 | 2111421.57011 | 37.7774951176523 | -122.447479040039 | (37.7774951176523, -122.447479040039) | 15 | 6 | 2 | 29492 | 16 | |||
48108 | 64515 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 720 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25396 | 6000553.55593738 | 2111421.0223091 | 37.7775900754915 | -122.441630952305 | (37.7775900754915, -122.441630952305) | 15 | 5 | 11 | 29490 | 41 |
44665 | 187544 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400 Somerset St | 4 | Side Yard : Yard | Tree | Private 2 | 16 | 6011380.55027 | 2088229.60878 | 37.71452238996 | -122.402545300722 | (37.71452238996, -122.402545300722) | 9 | 7 | 8 | 309 | 39 | ||||
44420 | 256875 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2449 Golden Gate Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |||||
44145 | 250581 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2201 Golden Gate Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5997509.51988 | 2111229.44513 | 37.7768901508918 | -122.452147418077 | (37.7768901508918, -122.452147418077) | 15 | 6 | 2 | 29492 | 16 | ||||
43342 | 120633 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
42070 | 30068 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 410X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | |||
41871 | 19437 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1300X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5987408.7322245 | 2095946.646093 | 37.7343439457369 | -122.485966609595 | (37.7343439457369, -122.485966609595) | 1 | 8 | 3 | 64 | 35 | |||
41580 | 190964 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Jack Balestreri Way | 36 | Front Yard : Yard | Tree | Private 2 | 16 | 6012433.13326 | 2104783.13919 | 37.7600336181869 | -122.400068950945 | (37.7600336181869, -122.400068950945) | 10 | 3 | 8 | 28856 | 29 | ||||
41433 | 19449 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5986974.9102614 | 2095954.0242956 | 37.7343389133904 | -122.48746699486 | (37.7343389133904, -122.48746699486) | 1 | 8 | 3 | 64 | 35 | |||
40066 | 250189 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 600 Parker Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 5997288.42031 | 2110933.51421 | 37.7760649338881 | -122.45289089929 | (37.7760649338881, -122.45289089929) | 15 | 6 | 2 | 29492 | 16 |
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) );