Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10226 | 10226 | 173925 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
10235 | 10235 | 173926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
10599 | 10599 | 25290 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000711.5604 | 2091742.5944599998 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | |||
10748 | 10748 | 47214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.4927400001 | 37.728594004685895 | -122.41174501811301 | (37.7285940046859, -122.411745018113) |
10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
10803 | 10803 | 25289 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000745.99488 | 2091748.7856599998 | 37.72358580881671 | -122.439554644937 | (37.7235858088167, -122.439554644937) | |||
11054 | 11054 | 1139 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | |||
11106 | 11106 | 25304 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.44296946786501 | (37.7231817335313, -122.442969467865) | |||
11402 | 11402 | 1130 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5998598.100380001 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | |||
11487 | 11487 | 110355 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.763380996470005 | -122.482748079472 | (37.76338099647, -122.482748079472) | |||
11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | |
11537 | 11537 | 25293 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175036998 | (37.7235513818789, -122.43985175037) | |||
11692 | 11692 | 77644 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | |
11709 | 11709 | 25297 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510352995 | -122.440332418218 | (37.723490510353, -122.440332418218) | |||
11719 | 11719 | 54938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.4266099995 | 2086907.8440900003 | 37.7109862260136 | -122.39667743572599 | (37.7109862260136, -122.396677435726) | |
12057 | 12057 | 77641 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006964.988919999 | 2093186.8525200002 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | |
12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
12673 | 12673 | 25310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000354.040159999 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | |||
13006 | 13006 | 25299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123001 | (37.7234515931109, -122.44068314123) | |||
13090 | 13090 | 77646 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | |
13198 | 13198 | 25303 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | |||
14180 | 14180 | 12213 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | |||
14202 | 14202 | 12169 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.38534947643299 | (37.7333003856228, -122.385349476433) | ||
14345 | 14345 | 25704 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | |||
14416 | 14416 | 12182 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.734530219899895 | -122.38599530928002 | (37.7345302198999, -122.38599530928) | |||
14433 | 14433 | 17144 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.5240900002 | 37.728978186084 | -122.38036919809099 | (37.728978186084, -122.380369198091) | ||
14646 | 14646 | 112141 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 299 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.780543667385395 | -122.403586031292 | (37.7805436673854, -122.403586031292) | |||
14762 | 14762 | 12188 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.734726794786404 | -122.386106718848 | (37.7347267947864, -122.386106718848) | |||
14796 | 14796 | 25703 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6012079.76947 | 2110324.35268 | 37.7752288341828 | -122.401680556721 | (37.7752288341828, -122.401680556721) | |||
14865 | 14865 | 12184 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.734332915157296 | -122.385929490724 | (37.7343329151573, -122.385929490724) | |||
15398 | 15398 | 6762 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782838999 | (37.7386467866108, -122.38268782839) | ||
15422 | 15422 | 12186 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138001 | (37.7346703842439, -122.38607488138) | |||
15662 | 15662 | 6752 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017539.76894 | 2096719.1679599998 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | |||
15744 | 15744 | 12173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.733673389774204 | -122.385645619675 | (37.7336733897742, -122.385645619675) | ||
15890 | 15890 | 17142 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.7049599998 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | ||
16102 | 16102 | 12179 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973632995 | -122.385668291381 | (37.733710973633, -122.385668291381) | |||
16260 | 16260 | 25705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.40160764957399 | (37.7751657827012, -122.401607649574) | |||
16320 | 16320 | 12187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | |||
16400 | 16400 | 1687 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.38081707126301 | (37.729651522897, -122.380817071263) | ||
16421 | 16421 | 12185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.734276365571105 | -122.385906337047 | (37.7342763655711, -122.385906337047) | |||
16425 | 16425 | 12214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693001 | (37.735503845269, -122.38712984693) | |||
16755 | 16755 | 12181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.733830726311396 | -122.385729969415 | (37.7338307263114, -122.385729969415) | |||
16766 | 16766 | 12174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016429.1110000005 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | |||
16816 | 16816 | 12175 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.733611910792796 | -122.385607138859 | (37.7336119107928, -122.385607138859) | |||
17086 | 17086 | 15318 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | |||
17247 | 17247 | 10229 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1417 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005889.94053 | 2100616.0721299998 | 37.748224824522296 | -122.422402655257 | (37.7482248245223, -122.422402655257) | |||
17503 | 17503 | 15320 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.770465880950496 | -122.419909204722 | (37.7704658809505, -122.419909204722) | ||
17545 | 17545 | 17038 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.772929678688506 | -122.43973803201 | (37.7729296786885, -122.43973803201) | |||
17605 | 17605 | 10230 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.42265570290199 | (37.7483007596771, -122.422655702902) | |||
17617 | 17617 | 26521 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 7.5x7 | 6009000.88013 | 2101922.6219900004 | 37.7519873190611 | -122.411737385595 | (37.7519873190611, -122.411737385595) | |||
17678 | 17678 | 10075 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 595 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6005616.34075 | 2105560.18901 | 37.7617847825636 | -122.423700237591 | (37.7617847825636, -122.423700237591) | |||
17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
17896 | 17896 | 10143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005657.84848 | 2103570.5399700003 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | |||
18011 | 18011 | 103601 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
18155 | 18155 | 1705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017900.557664401 | 2093604.0676713001 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | |||
18162 | 18162 | 10221 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6005802.11698 | 2100976.8322900003 | 37.7492104347131 | -122.42273198069599 | (37.7492104347131, -122.422731980696) | |||
18782 | 18782 | 10078 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 615 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005625.0168 | 2105365.53505 | 37.761250798395295 | -122.42365639023599 | (37.7612507983953, -122.423656390236) | |||
18810 | 18810 | 10105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 18 | 4x4 | 6005674.55908 | 2104459.44386 | 37.7587656810971 | -122.42342062756201 | (37.7587656810971, -122.423420627562) | ||
18862 | 18862 | 10055 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | |||
18911 | 18911 | 12302 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.42758319096399 | (37.7790930089412, -122.427583190964) | |||
19050 | 19050 | 4227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 5 | 3X3 | 6004005.18822 | 2100441.9925599997 | 37.7476403416378 | -122.428907662964 | (37.7476403416378, -122.428907662964) | ||
19071 | 19071 | 10185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005788.9112599995 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | |||
19433 | 19433 | 10011 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.76819027309789 | -122.424555388522 | (37.7681902730979, -122.424555388522) | |||
19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
19637 | 19637 | 100232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983809.619390001 | 2110917.38856 | 37.775239033091104 | -122.499515726535 | (37.7752390330911, -122.499515726535) | |||
19677 | 19677 | 55532 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | |||
19690 | 19690 | 69083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.761827789630104 | -122.470363712817 | (37.7618277896301, -122.470363712817) |
19863 | 19863 | 27655 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.770380480168704 | -122.419945578015 | (37.7703804801687, -122.419945578015) | |||
19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
20101 | 20101 | 10202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.42269187452601 | (37.7512674207747, -122.422691874526) | |||
20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
20212 | 20212 | 5507 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103988999 | (37.756512676133, -122.42575103989) | |||
20274 | 20274 | 10158 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | |||
20291 | 20291 | 61846 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | ||
20442 | 20442 | 19325 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 5993418.3820400005 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | |||
20535 | 20535 | 10072 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | |||
20844 | 20844 | 59583 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4071 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18981 | 6002727.56027236 | 2101791.13153415 | 37.7512723603586 | -122.433422018052 | (37.7512723603586, -122.433422018052) | ||
20855 | 20855 | 17135 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2033 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997261.7134 | 2109120.9259 | 37.771086505654104 | -122.45285242516701 | (37.7710865056541, -122.452852425167) | |||
21367 | 21367 | 10196 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005751.90575 | 2101904.66457 | 37.7517552157318 | -122.422971548421 | (37.7517552157318, -122.422971548421) | |||
21469 | 21469 | 15341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006768.902000001 | 2108274.3401 | 37.769302196475294 | -122.419906586242 | (37.7693021964753, -122.419906586242) | |||
21508 | 21508 | 16954 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | |||
21634 | 21634 | 24542 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500X Cortland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/29/1999 12:00:00 AM | 18 | 3X3 | 6007686.223540001 | 2097194.49045 | 37.7389310892969 | -122.41594888193701 | (37.7389310892969, -122.415948881937) | ||
21740 | 21740 | 26336 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997739.3987300005 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | |||
21805 | 21805 | 10058 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 6005573.3175800005 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | |||
21820 | 21820 | 10021 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x4 | 6005443.44254 | 2107417.66285 | 37.7668752034469 | -122.424430347706 | (37.7668752034469, -122.424430347706) | |||
22091 | 22091 | 10162 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005758.27618 | 2103002.2349099996 | 37.7547692495131 | -122.42302752222099 | (37.7547692495131, -122.423027522221) | |||
22133 | 22133 | 10187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005790.8424 | 2102360.27695 | 37.7530084192058 | -122.422869277503 | (37.7530084192058, -122.422869277503) | |||
22177 | 22177 | 10214 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | |||
22383 | 22383 | 1653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006219.57926 | 2115439.98405 | 37.788946349830105 | -122.42231585899401 | (37.7889463498301, -122.422315858994) | |||
22389 | 22389 | 23387 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006004.3296300005 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | |||
22439 | 22439 | 17748 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.42312054718501 | (37.7892164261498, -122.423120547185) | |||
22502 | 22502 | 1654 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 3X3 | 6006190.88992 | 2115436.6109700003 | 37.788935469840105 | -122.42241488063699 | (37.7889354698401, -122.422414880637) | ||
22641 | 22641 | 23386 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006045.46684 | 2115549.5575099997 | 37.789237388446296 | -122.422926056205 | (37.7892373884463, -122.422926056205) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");