trees
2,180 rows where qSpecies_id = 57 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
15507 | 207853 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992483.11623 | 2089580.88214 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | 9 | 8 | 6 | 64 | 24 | |||
19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
52506 | 207862 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Vernon St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5992461.4298 | 2088225.86047 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | 9 | 8 | 6 | 64 | 24 | |||
57591 | 207856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993273.29613 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | 9 | 8 | 6 | 64 | 24 | |||
58321 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 239x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 5987668 | 2090475 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | 1 | 8 | 4 | 64 | 14 | ||||
74377 | 177096 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5989524.60255 | 2090740.45181 | 37.7201721325212 | -122.478270901482 | (37.7201721325212, -122.478270901482) | 1 | 8 | 4 | 64 | 14 | ||||
82396 | 207854 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.7172015521901 | -122.467959759631 | (37.7172015521901, -122.467959759631) | 9 | 8 | 6 | 64 | 24 | |||
87418 | 256350 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
110484 | 207859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | 9 | 8 | 6 | 64 | 24 | |||
115045 | 207857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993273.27728 | 2090450.48631 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | 9 | 8 | 6 | 64 | 24 | |||
118234 | 19325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 5993418.38204 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | 9 | 8 | 6 | 64 | 24 | |||
119782 | 207860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992206.43527 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | 9 | 8 | 6 | 64 | 24 | |||
134830 | 177095 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | 1 | 8 | 4 | 64 | 14 | ||||
149901 | 256348 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
151518 | 207864 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2545 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991142.22279 | 2094819.87718 | 37.7314669887904 | -122.472976710428 | (37.7314669887904, -122.472976710428) | 1 | 8 | 4 | 64 | 40 | |||
153318 | 114098 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 219x VIDAL DR | 1 | Front Yard : Cutout | Tree | Private 2 | 40 | 5987664 | 2090565 | 37.7195822022131 | -122.484689437364 | (37.7195822022131, -122.484689437364) | 1 | 8 | 4 | 64 | 14 | ||||
162954 | 207858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 143 Garfield St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993571.00568 | 2090460.55199 | 37.7196376600192 | -122.464263641377 | (37.7196376600192, -122.464263641377) | 9 | 8 | 6 | 64 | 24 | |||
171591 | 207863 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 40 Lagunitas Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991134.49125 | 2095574.87688 | 37.7335395798715 | -122.47305847768 | (37.7335395798715, -122.47305847768) | 1 | 8 | 4 | 64 | 40 | |||
190462 | 207852 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 442 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5992499.13103 | 2090773.12014 | 37.7204340555615 | -122.467991417565 | (37.7204340555615, -122.467991417565) | 9 | 8 | 6 | 64 | 24 | |||
193853 | 256349 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 28 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
193998 | 207855 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993274.09777 | 2090428.40721 | 37.719532280163 | -122.465287603161 | (37.719532280163, -122.465287603161) | 9 | 8 | 6 | 64 | 24 | |||
2778 | 227271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001729.31648 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | 2 | 7 | 5 | 63 | 22 | |||
5540 | 64827 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 274 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | 2 | 7 | 5 | 63 | 22 | ||
7581 | 9343 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6000760.2622834 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | 2 | 7 | 5 | 63 | 7 | |||
8136 | 208000 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999487.48138 | 2094942.52217 | 37.7322833591869 | -122.444134470345 | (37.7322833591869, -122.444134470345) | 9 | 7 | 4 | 63 | 40 | |||
9052 | 227499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3068 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002862.42767 | 2095876.1703 | 37.7350389026183 | -122.432533184459 | (37.7350389026183, -122.432533184459) | 2 | 7 | 5 | 63 | 7 | |||
17665 | 227296 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4217 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002414.71515 | 2100605.94142 | 37.7480003546327 | -122.43441914105 | (37.7480003546327, -122.43441914105) | 2 | 4 | 5 | 63 | 22 | |||
21748 | 207991 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.443779078947 | (37.7324019240113, -122.443779078947) | 9 | 7 | 4 | 63 | 40 | ||||
22005 | 227490 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1893 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004623.20474 | 2097581.86585 | 37.7398220503353 | -122.426566965987 | (37.7398220503353, -122.426566965987) | 2 | 7 | 5 | 63 | 7 | |||
24180 | 227162 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 229 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6004860.09497 | 2100155.21835 | 37.7469012778702 | -122.425931032014 | (37.7469012778702, -122.425931032014) | 2 | 7 | 5 | 63 | 22 | |||
24777 | 121592 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002342 | 2100313 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | 2 | 4 | 5 | 63 | 22 | ||||
25015 | 54931 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | 2 | 7 | 5 | 63 | 22 | ||
31126 | 227328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 61 Elk St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6000814.1059 | 2096414.98301 | 37.7364019870456 | -122.439653561378 | (37.7364019870456, -122.439653561378) | 2 | 7 | 5 | 63 | 7 | |||
31163 | 227298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | 2 | 4 | 5 | 63 | 22 | ||||
32961 | 34389 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | 2 | 7 | 5 | 63 | 7 | ||
34855 | 227503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 31 Poppy Ln | 6 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6002189.282 | 2096805.2578 | 37.7375517667019 | -122.434926909075 | (37.7375517667019, -122.434926909075) | 2 | 7 | 5 | 63 | 7 | |||
37184 | 227290 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 685 29th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | 2 | 7 | 5 | 63 | 7 | ||||
38774 | 208003 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5999487.18878 | 2094935.81354 | 37.7322649221692 | -122.444135000042 | (37.7322649221692, -122.444135000042) | 9 | 7 | 4 | 63 | 40 | |||
39286 | 227300 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002388.83562 | 2100326.88873 | 37.7472326726441 | -122.434488682032 | (37.7472326726441, -122.434488682032) | 2 | 4 | 5 | 63 | 22 | ||||
39347 | 227502 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 46 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002908.65564 | 2097548.38173 | 37.739633032631 | -122.432492759035 | (37.739633032631, -122.432492759035) | 2 | 7 | 5 | 63 | 7 | |||
39407 | 227268 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | 2 | 7 | 5 | 63 | 22 | |||
40912 | 227306 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003270.17253 | 2099678.81961 | 37.7455032161105 | -122.431394832509 | (37.7455032161105, -122.431394832509) | 2 | 7 | 5 | 63 | 22 | |||
42241 | 227242 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 96 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000317.34123 | 2100126.86957 | 37.7465656607776 | -122.441637379485 | (37.7465656607776, -122.441637379485) | 2 | 7 | 5 | 63 | 22 | |||
44286 | 227491 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1893 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004617.88514 | 2097640.41879 | 37.7399825226668 | -122.426589527291 | (37.7399825226668, -122.426589527291) | 2 | 7 | 5 | 63 | 7 | |||
47088 | 246495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 359 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004220.12982 | 2099827.66275 | 37.7459656978564 | -122.428120633885 | (37.7459656978564, -122.428120633885) | 2 | 7 | 5 | 63 | 22 | |||
48384 | 227291 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 65 Zircon Pl | 4 | Front Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.434490777424 | (37.7428156470274, -122.434490777424) | 2 | 7 | 5 | 63 | 7 | |||
49213 | 207982 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 620 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999457.28605 | 2095077.61427 | 37.7326525677521 | -122.444248566437 | (37.7326525677521, -122.444248566437) | 9 | 7 | 4 | 63 | 40 | |||
51213 | 227504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 16 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002174.41423 | 2096447.25188 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | 2 | 7 | 5 | 63 | 7 | |||
53904 | 227496 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 424 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003932.93003 | 2096074.91076 | 37.7356452471229 | -122.428846240167 | (37.7356452471229, -122.428846240167) | 2 | 7 | 5 | 63 | 7 | |||
56613 | 227286 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 691 29th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6002107.89107 | 2098826.53454 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | 2 | 7 | 5 | 63 | 7 | ||||
56761 | 227297 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4220 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002396.17742 | 2100337.95193 | 37.7472634663454 | -122.434464085561 | (37.7472634663454, -122.434464085561) | 2 | 4 | 5 | 63 | 22 | ||||
58015 | 226754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 274 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004796.03332 | 2099028.36501 | 37.7438035765645 | -122.426072345162 | (37.7438035765645, -122.426072345162) | 2 | 7 | 5 | 63 | 22 | |||
58242 | 227273 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4321 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001793.87156 | 2100570.43846 | 37.7478676111151 | -122.43656344855 | (37.7478676111151, -122.43656344855) | 2 | 4 | 5 | 63 | 22 | |||
61305 | 226758 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 330 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003721.96059 | 2099552.94781 | 37.7451831959517 | -122.429823644066 | (37.7451831959517, -122.429823644066) | 2 | 7 | 5 | 63 | 22 | |||
62499 | 227327 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6003998.12904 | 2097070.3333 | 37.7383821413251 | -122.428691759122 | (37.7383821413251, -122.428691759122) | 2 | 7 | 5 | 63 | 7 | |||
63232 | 207993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999470.98074 | 2094940.54969 | 37.7322770018656 | -122.444191374942 | (37.7322770018656, -122.444191374942) | 9 | 7 | 4 | 63 | 40 | |||
63630 | 208002 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999487.23949 | 2094938.25423 | 37.7322716266247 | -122.444135000043 | (37.7322716266247, -122.444135000043) | 9 | 7 | 4 | 63 | 40 | |||
63813 | 227269 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001725.03317 | 2099972.93353 | 37.7462230919389 | -122.436758722841 | (37.7462230919389, -122.436758722841) | 2 | 7 | 5 | 63 | 22 | |||
65295 | 227493 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 250 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003939.93238 | 2097767.7283 | 37.7402937348636 | -122.428942681673 | (37.7402937348636, -122.428942681673) | 2 | 7 | 5 | 63 | 7 | |||
66551 | 227287 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 689 29th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6002120.49007 | 2098829.19814 | 37.7431051297892 | -122.435309486038 | (37.7431051297892, -122.435309486038) | 2 | 7 | 5 | 63 | 7 | ||||
66971 | 227288 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 689 29th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002143.45873 | 2098830.19502 | 37.7431091713442 | -122.435230137975 | (37.7431091713442, -122.435230137975) | 2 | 7 | 5 | 63 | 7 | ||||
67498 | 207978 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.7336328494621 | -122.438563716151 | (37.7336328494621, -122.438563716151) | 9 | 7 | 5 | 63 | 40 | |||
67780 | 226755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 209 Day St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004144.01902 | 2098653.98264 | 37.7427387360976 | -122.428300179912 | (37.7427387360976, -122.428300179912) | 2 | 7 | 5 | 63 | 22 | |||
68328 | 227500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3102 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002863.87446 | 2095783.29652 | 37.7347839744917 | -122.432521550824 | (37.7347839744917, -122.432521550824) | 2 | 7 | 5 | 63 | 7 | |||
68645 | 226757 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 209 Day St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6004291.47259 | 2098662.30016 | 37.7427699165123 | -122.427790919941 | (37.7427699165123, -122.427790919941) | 2 | 7 | 5 | 63 | 22 | |||
71438 | 227311 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | 2 | 7 | 5 | 63 | 7 | |||
71491 | 227274 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1533 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6002044.25876 | 2099560.43078 | 37.7451085935954 | -122.435625375609 | (37.7451085935954, -122.435625375609) | 2 | 7 | 5 | 63 | 22 | |||
72172 | 227325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 279 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004153.57623 | 2096841.70312 | 37.7377631712254 | -122.428138009677 | (37.7377631712254, -122.428138009677) | 2 | 7 | 5 | 63 | 7 | |||
78871 | 227307 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Beacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002310.77433 | 2098320.02828 | 37.7417178724744 | -122.434615134802 | (37.7417178724744, -122.434615134802) | 2 | 7 | 5 | 63 | 7 | |||
83199 | 9319 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
84333 | 227264 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 748 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6001689.2287 | 2099738.29729 | 37.7455768013454 | -122.436865735887 | (37.7455768013454, -122.436865735887) | 2 | 7 | 5 | 63 | 22 | ||||
84620 | 227505 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 11 Ohlone Way | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | 2 | 7 | 5 | 63 | 7 | |||
85676 | 226705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | 6004844.71466 | 2096725.50128 | 37.7374831871032 | -122.425740140092 | (37.7374831871032, -122.425740140092) | 2 | 7 | 5 | 63 | 7 | ||||
85895 | 207998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999486.80728 | 2094946.96177 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | 9 | 7 | 4 | 63 | 40 | |||
88040 | 227265 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 748 Duncan St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 6001689.18438 | 2099736.15615 | 37.7455709197615 | -122.436865735887 | (37.7455709197615, -122.436865735887) | 2 | 7 | 5 | 63 | 22 | ||||
88799 | 227299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002389.0649 | 2100323.63751 | 37.7472237585745 | -122.434487656775 | (37.7472237585745, -122.434487656775) | 2 | 4 | 5 | 63 | 22 | ||||
89008 | 227301 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 561 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002902.81883 | 2099758.38462 | 37.7457008565084 | -122.432670765459 | (37.7457008565084, -122.432670765459) | 2 | 7 | 5 | 63 | 22 | |||
89040 | 227326 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 279 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004157.53404 | 2096855.56287 | 37.7378014508791 | -122.428125313042 | (37.7378014508791, -122.428125313042) | 2 | 7 | 5 | 63 | 7 | |||
92023 | 227276 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 91 Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001604.247 | 2099100.29306 | 37.7438201618758 | -122.437113918188 | (37.7438201618758, -122.437113918188) | 2 | 7 | 5 | 63 | 22 | |||
92605 | 227295 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4257 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6002219.59869 | 2100594.97357 | 37.7479591620835 | -122.435093060598 | (37.7479591620835, -122.435093060598) | 2 | 4 | 5 | 63 | 22 | |||
92830 | 227272 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4331 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001752.41046 | 2100271.74966 | 37.7470451262446 | -122.4366854416 | (37.7470451262446, -122.4366854416) | 2 | 4 | 5 | 63 | 22 | |||
102212 | 51620 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 419 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48838 | 6004007.75048659 | 2096078.78682851 | 37.7356601244905 | -122.428587833263 | (37.7356601244905, -122.428587833263) | 2 | 7 | 5 | 63 | 7 | |||
108280 | 227266 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | 2 | 7 | 5 | 63 | 22 | ||||
109724 | 9317 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | ||
113159 | 227294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4271 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6002167.60726 | 2100591.89934 | 37.7479477685938 | -122.435272624637 | (37.7479477685938, -122.435272624637) | 2 | 4 | 5 | 63 | 22 | |||
115057 | 34423 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47622 | 6003411.17015121 | 2096158.68200715 | 37.7358457184137 | -122.430656139914 | (37.7358457184137, -122.430656139914) | 2 | 7 | 5 | 63 | 7 | ||
116353 | 227267 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | 2 | 7 | 5 | 63 | 22 | |||
118950 | 207983 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 620 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.444237267358 | (37.7326518231051, -122.444237267358) | 9 | 7 | 4 | 63 | 40 | |||
121327 | 207994 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999470.93523 | 2094944.41877 | 37.7322876228558 | -122.444191810206 | (37.7322876228558, -122.444191810206) | 9 | 7 | 4 | 63 | 40 | |||
122613 | 227308 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Beacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002314.2643 | 2098316.80791 | 37.7417092282111 | -122.434602837447 | (37.7417092282111, -122.434602837447) | 2 | 7 | 5 | 63 | 7 | |||
127158 | 63919 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 361 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/1988 12:00:00 AM | Permit Number 24639 | 6004187.93187702 | 2099820.2683611 | 37.745943572802 | -122.428231443138 | (37.745943572802, -122.428231443138) | 2 | 7 | 5 | 63 | 22 | ||
128035 | 56255 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 250 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 12 | 3x3 | Permit Number 12381 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | 2 | 7 | 5 | 63 | 7 | |
128787 | 227303 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.433235515417 | (37.7437280128274, -122.433235515417) | 2 | 7 | 5 | 63 | 22 | ||||
129037 | 227309 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Beacon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002319.69517 | 2098302.33211 | 37.7416697893392 | -122.434583024505 | (37.7416697893392, -122.434583024505) | 2 | 7 | 5 | 63 | 7 | |||
129502 | 208007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000194.86676 | 2094049.10178 | 37.7298705644518 | -122.441624792557 | (37.7298705644518, -122.441624792557) | 9 | 7 | 4 | 63 | 40 | |||
133662 | 226759 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1310 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003860.87031 | 2100604.43164 | 37.7480781918547 | -122.429418288125 | (37.7480781918547, -122.429418288125) | 2 | 4 | 5 | 63 | 22 | |||
136462 | 226760 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3957 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004151.37818 | 2100700.21815 | 37.748357642705 | -122.428420548782 | (37.748357642705, -122.428420548782) | 2 | 4 | 5 | 63 | 22 | |||
136976 | 227245 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000206.60136 | 2100087.03899 | 37.7464499854925 | -122.442017446473 | (37.7464499854925, -122.442017446473) | 2 | 7 | 5 | 63 | 22 | |||
137555 | 227310 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Beacon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002320.65439 | 2098300.93501 | 37.7416660076813 | -122.434579607974 | (37.7416660076813, -122.434579607974) | 2 | 7 | 5 | 63 | 7 |
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) );