trees
2,180 rows where qSpecies_id = 57 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187589 | 226701 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 92 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005200.1443 | 2107296.60066 | 37.7665290534961 | -122.425263261998 | (37.7665290534961, -122.425263261998) | 8 | 4 | 5 | 28853 | 19 | |||
| 187536 | 244025 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5997747.9602 | 2108846.3652 | 37.7703604843866 | -122.451150685898 | (37.7703604843866, -122.451150685898) | 15 | 5 | 11 | 29492 | 9 | |||
| 187519 | 10058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 6005573.31758 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | 8 | 4 | 5 | 28859 | 19 | |||
| 187497 | 226660 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | 8 | 4 | 5 | 28862 | 3 | |||
| 187389 | 227313 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4335 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000842.8019 | 2102273.68365 | 37.7524902217542 | -122.439974303674 | (37.7524902217542, -122.439974303674) | 2 | 4 | 5 | 28862 | 22 | |||
| 187349 | 67005 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | 9 | 8 | 6 | 28861 | 24 | ||
| 187209 | 246219 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999330.036 | 2107911.9334 | 37.7678852241105 | -122.445611099483 | (37.7678852241105, -122.445611099483) | 15 | 5 | 11 | 29492 | 9 | |||
| 187081 | 207929 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995760.63845 | 2092696.43129 | 37.7259028185378 | -122.456856543506 | (37.7259028185378, -122.456856543506) | 9 | 7 | 4 | 28861 | 40 | |||
| 187018 | 177071 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Allison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | 9 | 7 | 6 | 28861 | 5 | |||
| 186921 | 227385 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2960 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008461.00533 | 2103907.51298 | 37.7574070797942 | -122.413744741651 | (37.7574070797942, -122.413744741651) | 2 | 4 | 7 | 28859 | 19 | |||
| 186820 | 141898 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 921 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004805.1586 | 2112039.2549 | 37.7795289070448 | -122.426967262784 | (37.7795289070448, -122.426967262784) | 7 | 9 | 11 | 29490 | 41 | |||
| 186811 | 191482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012422.29694 | 2111134.3733 | 37.7774720734215 | -122.400552582046 | (37.7774720734215, -122.400552582046) | 14 | 2 | 9 | 28856 | 34 | |||
| 186770 | 200629 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1433 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016516.3925 | 2094928.5537 | 37.7332017742072 | -122.385260102357 | (37.7332017742072, -122.385260102357) | 10 | 3 | 8 | 58 | 1 | |||
| 186561 | 138111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2109 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003316.4709 | 2114827.0332 | 37.7870991560456 | -122.432316422563 | (37.7870991560456, -122.432316422563) | 13 | 9 | 11 | 29490 | 27 | |||
| 186541 | 140575 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1225 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003289.1195 | 2111701.1038 | 37.7785145879996 | -122.432187730185 | (37.7785145879996, -122.432187730185) | 15 | 9 | 11 | 29492 | 41 | |||
| 186530 | 227176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 79 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998188.77649 | 2106519.06187 | 37.7639955293052 | -122.449458194243 | (37.7639955293052, -122.449458194243) | 15 | 5 | 11 | 29492 | 9 | |||
| 186317 | 111081 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2811 14TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992341 | 2097126 | 37.7378683540452 | -122.469000113007 | (37.7378683540452, -122.469000113007) | 1 | 8 | 4 | 59 | 40 | ||||
| 186253 | 226749 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6004787.62152 | 2108995.19732 | 37.7711696766722 | -122.426811085178 | (37.7711696766722, -122.426811085178) | 7 | 9 | 5 | 28852 | 10 | |||
| 186204 | 226741 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010258.15584 | 2102463.06737 | 37.7535417126867 | -122.407427621191 | (37.7535417126867, -122.407427621191) | 2 | 4 | 7 | 28859 | 19 | |||
| 186147 | 227498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3068 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002861.44894 | 2095908.97167 | 37.7351289121778 | -122.432538910449 | (37.7351289121778, -122.432538910449) | 2 | 7 | 5 | 63 | 7 | |||
| 186136 | 62787 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.7235390694702 | -122.440231199397 | (37.7235390694702, -122.440231199397) | 9 | 7 | 6 | 28861 | 25 | ||
| 186047 | 227462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999847.6804 | 2105560.72227 | 37.7614589240024 | -122.44365170527 | (37.7614589240024, -122.44365170527) | 15 | 5 | 5 | 28862 | 3 | |||
| 186036 | 252819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479 | 2096413 | 37.7366044563371 | -122.426982337456 | (37.7366044563371, -122.426982337456) | 2 | 7 | 5 | 63 | 7 | ||
| 186032 | 227440 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4110 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002948.63502 | 2104191.86792 | 37.7578767516247 | -122.432829004754 | (37.7578767516247, -122.432829004754) | 2 | 4 | 5 | 28862 | 3 | |||
| 185883 | 227516 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1175 Stevenson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006494.66605 | 2109620.24654 | 37.772982280939 | -122.420950728601 | (37.772982280939, -122.420950728601) | 8 | 2 | 9 | 28853 | 19 | |||
| 185700 | 249627 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.451766359136 | (37.777145918089, -122.451766359136) | 15 | 6 | 2 | 54 | 16 | |||
| 185660 | 227367 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1164 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008044.22977 | 2101142.15032 | 37.7497906071608 | -122.414990395294 | (37.7497906071608, -122.414990395294) | 2 | 4 | 7 | 28859 | 19 | |||
| 185483 | 32771 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.7743183510223 | -122.440968898129 | (37.7743183510223, -122.440968898129) | 15 | 5 | 11 | 29492 | 10 | ||
| 185359 | 227454 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 31 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003284.13027 | 2107394.52295 | 37.7666894934374 | -122.431897401555 | (37.7666894934374, -122.431897401555) | 15 | 5 | 5 | 28862 | 3 | |||
| 185357 | 191454 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.7909276399352 | -122.393974517007 | (37.7909276399352, -122.393974517007) | 12 | 2 | 9 | 28855 | 6 | |||
| 185337 | 129572 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2267 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000506.86895 | 2119922.56555 | 37.8009304402543 | -122.442402956127 | (37.8009304402543, -122.442402956127) | 13 | 9 | 1 | 57 | 17 | |||
| 185329 | 120302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 361 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5988369.83373 | 2113569.61422 | 37.7827878063085 | -122.483935624743 | (37.7827878063085, -122.483935624743) | 11 | 6 | 2 | 55 | 26 | |||
| 185308 | 65177 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27158 | 6002678.99460756 | 2090431.51316854 | 37.7200786982312 | -122.43277855471 | (37.7200786982312, -122.43277855471) | 9 | 7 | 6 | 28861 | 5 | ||
| 185273 | 177130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006962.96943 | 2093340.12514 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | 9 | 3 | 7 | 309 | 5 | |||
| 185263 | 227434 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 85 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000651.93806 | 2104891.30912 | 37.7596667172723 | -122.440822097265 | (37.7596667172723, -122.440822097265) | 2 | 4 | 5 | 28862 | 3 | |||
| 185197 | 227339 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008435.91827 | 2096862.8615 | 37.7380626292878 | -122.413333329675 | (37.7380626292878, -122.413333329675) | 10 | 7 | 7 | 28859 | 2 | |||
| 185135 | 58462 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 245 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 4x3 | Permit Number 17616 | 5998964.32399237 | 2106748.99637292 | 37.7646712060943 | -122.446792361644 | (37.7646712060943, -122.446792361644) | 15 | 5 | 11 | 29492 | 9 | |
| 185111 | 227511 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 Brady St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006521.37542 | 2109731.86389 | 37.7732902609724 | -122.420866263385 | (37.7732902609724, -122.420866263385) | 8 | 2 | 9 | 28853 | 19 | |||
| 184702 | 207392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1253 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993282.42439 | 2106968.20493 | 37.7649468708334 | -122.466460318185 | (37.7649468708334, -122.466460318185) | 11 | 8 | 11 | 56 | 12 | |||
| 184655 | 123763 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 773 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5993290.50401 | 2110687.91743 | 37.7751606787212 | -122.466702781809 | (37.7751606787212, -122.466702781809) | 11 | 6 | 2 | 54 | 11 | |||
| 184585 | 14807 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1160X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003602.65321 | 2111793.09154 | 37.7787849351465 | -122.431109665833 | (37.7787849351465, -122.431109665833) | 15 | 9 | 11 | 29490 | 41 | |||
| 184447 | 61841 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.407434066583 | (37.7552975843096, -122.407434066583) | 10 | 4 | 7 | 28859 | 19 | ||
| 184435 | 191450 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Fairfax Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.7392132974473 | -122.383283724566 | (37.7392132974473, -122.383283724566) | 10 | 3 | 8 | 58 | 1 | |||
| 184419 | 68922 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1255 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 9 | Permit Number 32906 | 6007550.61627 | 2118479.08218 | 37.7973659521424 | -122.417926160173 | (37.7973659521424, -122.417926160173) | 5 | 1 | 10 | 28858 | 32 | |
| 184358 | 227419 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6001166.24895 | 2104139.2596 | 37.7576310496535 | -122.438989458796 | (37.7576310496535, -122.438989458796) | 2 | 4 | 5 | 28862 | 3 | |||
| 184262 | 61346 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2966 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1984 12:00:00 AM | 5 | Permit Number 21251 | 5999326.7118 | 2114325.9429 | 37.7854962600715 | -122.446084001806 | (37.7854962600715, -122.446084001806) | 15 | 6 | 1 | 29490 | 31 | ||
| 184249 | 207949 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992678.23044 | 2100499.52384 | 37.7471506733823 | -122.468079477383 | (37.7471506733823, -122.468079477383) | 1 | 8 | 4 | 29491 | 40 | |||
| 184196 | 122755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.404117444276 | (37.7615439863765, -122.404117444276) | 10 | 3 | 8 | 28856 | 29 | |||
| 184153 | 65899 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 166 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | 8 | Permit Number 28906 | 5995945.57364 | 2113203.14409 | 37.7822196931154 | -122.45770039604 | (37.7822196931154, -122.45770039604) | 11 | 6 | 1 | 54 | 31 | |
| 184036 | 12181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.7338307263114 | -122.385729969415 | (37.7338307263114, -122.385729969415) | 10 | 3 | 8 | 58 | 1 | |||
| 183933 | 37549 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | 5 | 1 | 10 | 28852 | 36 | ||
| 183831 | 102192 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
| 183786 | 122271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1600 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990587.5386 | 2111332.78753 | 37.7767749549722 | -122.476099955577 | (37.7767749549722, -122.476099955577) | 11 | 6 | 2 | 55 | 26 | |||
| 183785 | 227198 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 436 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008578.58301 | 2096789.13925 | 37.7378682129375 | -122.412834854355 | (37.7378682129375, -122.412834854355) | 10 | 7 | 7 | 28859 | 2 | |||
| 183763 | 207383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1313 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993603.85534 | 2106592.86022 | 37.7639348151617 | -122.465321311525 | (37.7639348151617, -122.465321311525) | 1 | 8 | 11 | 56 | 12 | |||
| 183628 | 227221 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007877.8147 | 2104842.60134 | 37.7599418504554 | -122.415827864682 | (37.7599418504554, -122.415827864682) | 2 | 4 | 7 | 28859 | 19 | |||
| 183576 | 207390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993751.42285 | 2103698.23694 | 37.7559954409591 | -122.464600723458 | (37.7559954409591, -122.464600723458) | 1 | 8 | 4 | 56 | 12 | |||
| 183551 | 208011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998765.6075 | 2093383.38931 | 37.7279611382792 | -122.446518012793 | (37.7279611382792, -122.446518012793) | 9 | 7 | 4 | 28861 | 40 | |||
| 183547 | 207844 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995613.36953 | 2090975.38331 | 37.721168773811 | -122.457241192529 | (37.721168773811, -122.457241192529) | 9 | 8 | 6 | 28861 | 24 | |||
| 183438 | 31871 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 120 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35312 | 5999385.97984 | 2107527.91309 | 37.766833994712 | -122.445389981477 | (37.766833994712, -122.445389981477) | 15 | 5 | 5 | 29492 | 9 | ||
| 183421 | 248438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998841.1184 | 2107924.1979 | 37.7678909740755 | -122.447303085161 | (37.7678909740755, -122.447303085161) | 15 | 5 | 11 | 29492 | 9 | |||
| 183341 | 227282 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4412 23rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 6000544.37543 | 2102304.8503 | 37.7525588049644 | -122.441008545612 | (37.7525588049644, -122.441008545612) | 2 | 4 | 5 | 28862 | 22 | |||
| 183327 | 248520 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 218 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998876.5494 | 2107680.7234 | 37.767224479143 | -122.447163009367 | (37.767224479143, -122.447163009367) | 15 | 5 | 11 | 29492 | 9 | |||
| 183319 | 101143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.7605945388373 | -122.397410636805 | (37.7605945388373, -122.397410636805) | 10 | 3 | 8 | 28856 | 29 | |||
| 183293 | 207970 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 63 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998594.46652 | 2095921.95645 | 37.7349216678915 | -122.447292281422 | (37.7349216678915, -122.447292281422) | 9 | 7 | 4 | 59 | 40 | |||
| 183264 | 12175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.7336119107928 | -122.385607138859 | (37.7336119107928, -122.385607138859) | 10 | 3 | 8 | 58 | 1 | |||
| 183073 | 123767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993113.80746 | 2110684.76111 | 37.7751418134998 | -122.467313779933 | (37.7751418134998, -122.467313779933) | 11 | 6 | 2 | 54 | 11 | |||
| 182995 | 207890 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1585 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991722.66057 | 2104556.34539 | 37.7582344164913 | -122.47167932057 | (37.7582344164913, -122.47167932057) | 1 | 8 | 4 | 56 | 12 | |||
| 182953 | 17111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1837 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5998183.72781 | 2109230.99806 | 37.7714415276809 | -122.449671093805 | (37.7714415276809, -122.449671093805) | 15 | 5 | 11 | 29492 | 9 | |||
| 182926 | 20268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
| 182849 | 191466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 86 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014334.84424 | 2112669.08128 | 37.781792510069 | -122.394043861033 | (37.781792510069, -122.394043861033) | 6 | 2 | 9 | 28856 | 6 | |||
| 182830 | 122093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990957.61701 | 2110561.83136 | 37.7746795727782 | -122.474763472642 | (37.7746795727782, -122.474763472642) | 11 | 6 | 2 | 54 | 26 | |||
| 182748 | 227196 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 434 Banks St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008563.57852 | 2096642.27397 | 37.7374641106746 | -122.412876351788 | (37.7374641106746, -122.412876351788) | 10 | 7 | 7 | 28859 | 2 | |||
| 182696 | 65630 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2510 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1990 12:00:00 AM | 8 | Permit Number 28538 | 6001388.347 | 2114610.3564 | 37.7863947012265 | -122.438971757707 | (37.7863947012265, -122.438971757707) | 13 | 6 | 1 | 29490 | 27 | |
| 182672 | 62826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 170 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | 8 | Permit Number 23191 | 6000498.41934 | 2091715.94048 | 37.7234815297285 | -122.440408113263 | (37.7234815297285, -122.440408113263) | 9 | 7 | 6 | 28861 | 25 | |
| 182535 | 100232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983809.61939 | 2110917.38856 | 37.7752390330911 | -122.499515726535 | (37.7752390330911, -122.499515726535) | 11 | 6 | 2 | 55 | 26 | |||
| 182521 | 250113 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006068.77978 | 2115421.44634 | 37.7888869424356 | -122.422836287668 | (37.7888869424356, -122.422836287668) | 13 | 9 | 1 | 28858 | 41 | |||
| 182509 | 226747 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004809.8918 | 2108865.505 | 37.7708148320814 | -122.426724814115 | (37.7708148320814, -122.426724814115) | 7 | 9 | 5 | 28852 | 10 | |||
| 182503 | 177053 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998955.22978 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | 9 | 7 | 6 | 28861 | 25 | |||
| 182466 | 109255 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1533 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2015 12:00:00 AM | 3 | 3x3 | 6006572.5 | 2115603.9 | 37.78941632368 | -122.421106442083 | (37.78941632368, -122.421106442083) | 13 | 9 | 10 | 28858 | 21 | ||
| 182355 | 141958 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 889 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004829.9126 | 2111886.0966 | 37.7791097717212 | -122.426870717393 | (37.7791097717212, -122.426870717393) | 7 | 9 | 11 | 28852 | 41 | |||
| 182319 | 227217 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 775 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009108.8338 | 2104653.10632 | 37.7594906686717 | -122.411556961793 | (37.7594906686717, -122.411556961793) | 2 | 4 | 7 | 28859 | 19 | |||
| 182293 | 17714 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1230 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002319.96855 | 2112800.43345 | 37.7814780741875 | -122.435619055061 | (37.7814780741875, -122.435619055061) | 15 | 5 | 11 | 29490 | 41 | |||
| 182117 | 227178 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998416.90263 | 2106245.44708 | 37.7632572991966 | -122.448649468997 | (37.7632572991966, -122.448649468997) | 15 | 5 | 11 | 29492 | 9 | |||
| 182054 | 227513 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1175 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006417.50309 | 2109544.96147 | 37.7727712163415 | -122.421212298229 | (37.7727712163415, -122.421212298229) | 8 | 2 | 9 | 28853 | 19 | |||
| 181938 | 17711 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1214 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002331.3974 | 2112685.404 | 37.7811628814816 | -122.435571285126 | (37.7811628814816, -122.435571285126) | 15 | 5 | 11 | 29490 | 41 | |||
| 181643 | 138668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1714 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999604.5625 | 2114731.8754 | 37.7866267078022 | -122.445151918257 | (37.7866267078022, -122.445151918257) | 15 | 6 | 1 | 29490 | 31 | |||
| 181602 | 60022 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 64 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | 6 | 2 | 9 | 28856 | 6 | ||
| 181485 | 226662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004759.39323 | 2108882.79631 | 37.7708594546408 | -122.426900721499 | (37.7708594546408, -122.426900721499) | 7 | 9 | 11 | 28852 | 10 | |||
| 181453 | 129623 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1914 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008683.00237 | 2119409.78027 | 37.7999850828041 | -122.414073675855 | (37.7999850828041, -122.414073675855) | 3 | 1 | 10 | 308 | 32 | |||
| 181449 | 122137 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083 | (37.786826966306, -122.47453884083) | 11 | 6 | 1 | 54 | 33 | ||||
| 181374 | 177052 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998953.78777 | 2090172.93818 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | 9 | 7 | 6 | 28861 | 25 | |||
| 181372 | 217652 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 28 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5993152.0713 | 2098090.8113 | 37.7405643124274 | -122.466265963968 | (37.7405643124274, -122.466265963968) | 1 | 8 | 4 | 59 | 40 | |||
| 181341 | 246057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 648 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999017.3649 | 2108458.6913 | 37.7693686271191 | -122.44673193378 | (37.7693686271191, -122.44673193378) | 15 | 5 | 11 | 29492 | 9 | |||
| 181255 | 177133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006981.25379 | 2093279.99997 | 37.7281430972085 | -122.418108906001 | (37.7281430972085, -122.418108906001) | 9 | 3 | 7 | 309 | 5 | |||
| 181246 | 227292 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1831 Castro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002653.15618 | 2100170.70248 | 37.7468188226239 | -122.433563522461 | (37.7468188226239, -122.433563522461) | 2 | 7 | 5 | 63 | 22 | ||||
| 181216 | 227438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 694 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002372.88871 | 2104189.13558 | 37.7578365780034 | -122.434819978772 | (37.7578365780034, -122.434819978772) | 2 | 4 | 5 | 28862 | 3 | |||
| 181148 | 87383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 431 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 11 | 3x3 | Permit Number 50363 | 5997173.61731 | 2114868.15858 | 37.7868618517374 | -122.453572197813 | (37.7868618517374, -122.453572197813) | 11 | 6 | 1 | 54 | 31 | |
| 181135 | 33186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | 1 | 5 | 4 | 59 | 40 | ||
| 180952 | 227256 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006035.34272 | 2096387.96537 | 37.7366235979955 | -122.421599606546 | (37.7366235979955, -122.421599606546) | 2 | 7 | 7 | 28859 | 2 |
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) );