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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194489 | 64389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.7854381817627 | -122.421152111986 | (37.7854381817627, -122.421152111986) | 13 | 9 | 9 | 28858 | 36 | ||
| 194115 | 208012 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998765.71342 | 2093368.99771 | 37.7279216283624 | -122.446516611665 | (37.7279216283624, -122.446516611665) | 9 | 7 | 4 | 28861 | 40 | |||
| 194071 | 142062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | 7 | 9 | 11 | 29490 | 41 | |
| 194043 | 207958 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Woodside Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995753.89015 | 2100245.58551 | 37.7466305648554 | -122.457425790981 | (37.7466305648554, -122.457425790981) | 1 | 5 | 4 | 59 | 40 | |||
| 194010 | 120978 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
| 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 | |||
| 193988 | 227388 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3016 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009153.44991 | 2104528.30813 | 37.7591505037244 | -122.411393840047 | (37.7591505037244, -122.411393840047) | 2 | 4 | 7 | 28859 | 19 | |||
| 193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 193890 | 207919 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993555.00989 | 2095089.8986 | 37.7323477938127 | -122.464654913005 | (37.7323477938127, -122.464654913005) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 193836 | 12192 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016272.6778818 | 2095480.4561364 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | 10 | 3 | 8 | 58 | 1 | |||
| 193809 | 109820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
| 193796 | 120479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5988612.47401 | 2114641.5086 | 37.785745047419 | -122.483174795713 | (37.785745047419, -122.483174795713) | 11 | 6 | 2 | 55 | 26 | |||
| 193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 193426 | 10214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | 2 | 4 | 5 | 28859 | 19 | |||
| 193421 | 129608 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005921.62398 | 2117595.14821 | 37.7948470796741 | -122.423500026015 | (37.7948470796741, -122.423500026015) | 13 | 9 | 1 | 28858 | 27 | |||
| 193416 | 129641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 943 Green St | 12 | Side Yard : Yard | Tree | Private 2 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.414066792462 | (37.7987948111981, -122.414066792462) | 5 | 1 | 10 | 308 | 21 | ||||
| 193334 | 138738 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2951 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999390.3943 | 2114276.6324 | 37.7853645026984 | -122.44586013228 | (37.7853645026984, -122.44586013228) | 15 | 6 | 1 | 29490 | 31 | |||
| 193328 | 61864 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1266 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | 11 | 3x3 | Permit Number 21904 | 6010288.23074759 | 2101843.68563372 | 37.7518427109773 | -122.407279955435 | (37.7518427109773, -122.407279955435) | 2 | 4 | 7 | 28859 | 19 |
| 193318 | 114467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009280.92289 | 2121766.47886 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | 3 | 1 | 10 | 308 | 23 | |||
| 193303 | 245070 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 6 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000404.9733 | 2108969.9375 | 37.7708515497475 | -122.441968974427 | (37.7708515497475, -122.441968974427) | 15 | 5 | 11 | 29492 | 9 | |||
| 193285 | 139004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 155 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998267.7815 | 2110059.6372 | 37.7737215666049 | -122.449440064586 | (37.7737215666049, -122.449440064586) | 15 | 5 | 11 | 29492 | 16 | |||
| 193271 | 177064 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 France Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | 9 | 7 | 6 | 28861 | 5 | |||
| 193216 | 68829 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | 9 | 7 | 4 | 63 | 40 | ||
| 193189 | 15426 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) | 8 | 4 | 7 | 28859 | 19 | |||
| 193145 | 5074 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.437054001757 | (37.73828941133, -122.437054001757) | 2 | 7 | 5 | 63 | 7 | |||
| 193006 | 62617 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 608 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1986 12:00:00 AM | 7 | Permit Number 22927 | 6001463.88334 | 2090119.93819 | 37.719154192602 | -122.436956480181 | (37.719154192602, -122.436956480181) | 9 | 7 | 6 | 28861 | 5 | ||
| 192971 | 64518 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 512 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | Permit Number 25400 | 6000652.29265662 | 2110712.76052634 | 37.7756509932088 | -122.441238559661 | (37.7756509932088, -122.441238559661) | 15 | 5 | 11 | 29492 | 10 | ||
| 192854 | 207922 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993570.7217 | 2095074.32308 | 37.732305933067 | -122.464599463503 | (37.732305933067, -122.464599463503) | 9 | 8 | 4 | 59 | 40 | |||
| 192754 | 66835 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.7888240893158 | -122.41198018251 | (37.7888240893158, -122.41198018251) | 5 | 1 | 10 | 28858 | 21 | ||
| 192704 | 227281 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4181 23rd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001938.68503 | 2102334.04898 | 37.7527182943203 | -122.436188880937 | (37.7527182943203, -122.436188880937) | 2 | 4 | 5 | 28862 | 22 | |||
| 192535 | 54531 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | 11 | 6 | 2 | 55 | 26 | ||
| 192501 | 14791 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
| 192483 | 207818 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997421.24463 | 2093919.55877 | 37.7293564526293 | -122.451204139877 | (37.7293564526293, -122.451204139877) | 9 | 7 | 4 | 28861 | 40 | |||
| 192433 | 207827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999363.86559 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | 9 | 7 | 4 | 28861 | 40 | |||
| 192329 | 200062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014902.219 | 2094116.2312 | 37.7308818705774 | -122.390784034613 | (37.7308818705774, -122.390784034613) | 10 | 3 | 8 | 58 | 1 | |||
| 192319 | 207913 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994687.05198 | 2099628.96292 | 37.7448761386401 | -122.461070093006 | (37.7448761386401, -122.461070093006) | 1 | 8 | 4 | 59 | 40 | |||
| 192226 | 227429 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 304 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001107.53078 | 2104586.38351 | 37.7588554019715 | -122.439224576655 | (37.7588554019715, -122.439224576655) | 2 | 4 | 5 | 28862 | 38 | |||
| 191692 | 121621 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
| 191597 | 227497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 397 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004100.29767 | 2096157.27235 | 37.7358808650082 | -122.42827345387 | (37.7358808650082, -122.42827345387) | 2 | 7 | 5 | 63 | 7 | |||
| 191537 | 207380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1251 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5992036.83974 | 2106822.46143 | 37.7644747447354 | -122.470757824839 | (37.7644747447354, -122.470757824839) | 11 | 8 | 11 | 56 | 12 | |||
| 191258 | 129594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005803.86488 | 2117245.73922 | 37.793881043227 | -122.423882631794 | (37.793881043227, -122.423882631794) | 13 | 9 | 1 | 28858 | 27 | |||
| 191231 | 101261 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989742 | 2106485 | 37.7634151902649 | -122.478670277794 | (37.7634151902649, -122.478670277794) | 1 | 8 | 3 | 56 | 35 | ||||
| 191092 | 227216 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 775 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009109.62388 | 2104630.73399 | 37.7594292836568 | -122.41155264863 | (37.7594292836568, -122.41155264863) | 2 | 4 | 7 | 28859 | 19 | |||
| 191080 | 227316 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4336 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000997.33925 | 2102323.34435 | 37.7526353741216 | -122.43944344826 | (37.7526353741216, -122.43944344826) | 2 | 4 | 5 | 28862 | 22 | |||
| 191069 | 227173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 146 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997978.59141 | 2106212.21025 | 37.763140966494 | -122.450163039697 | (37.763140966494, -122.450163039697) | 15 | 5 | 11 | 29492 | 9 | |||
| 190969 | 12205 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 190925 | 92919 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5991957 | 2096928 | 37.7373025018195 | -122.470313361151 | (37.7373025018195, -122.470313361151) | 1 | 8 | 4 | 59 | 40 | ||||
| 190827 | 177041 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 5999256.25941 | 2089431.5407 | 37.7171382857881 | -122.444537916099 | (37.7171382857881, -122.444537916099) | 9 | 7 | 6 | 28861 | 25 | |||
| 190796 | 191464 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014410.76639 | 2112744.50721 | 37.7820038318593 | -122.393786484975 | (37.7820038318593, -122.393786484975) | 6 | 2 | 9 | 28856 | 6 | |||
| 190683 | 36156 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996550.482 | 2114121.4423 | 37.7847758271364 | -122.455674094114 | (37.7847758271364, -122.455674094114) | 11 | 6 | 1 | 54 | 31 | |
| 190600 | 207956 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Woodside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995766.68193 | 2100244.56754 | 37.7466285044959 | -122.457381484986 | (37.7466285044959, -122.457381484986) | 1 | 5 | 4 | 59 | 40 | |||
| 190561 | 58421 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 68 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1979 12:00:00 AM | 6x3.5 | Permit Number 17560 | 5999339.95243749 | 2107930.01507988 | 37.7679354379891 | -122.445578100195 | (37.7679354379891, -122.445578100195) | 15 | 5 | 11 | 29492 | 9 | ||
| 190472 | 60025 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 155 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.394449015999 | (37.7813091831039, -122.394449015999) | 6 | 2 | 9 | 28856 | 6 | ||
| 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 | |||
| 190453 | 201856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010248.3954 | 2110901.8137 | 37.7767120417305 | -122.408056457346 | (37.7767120417305, -122.408056457346) | 8 | 2 | 9 | 28853 | 34 | |||
| 190312 | 62706 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23046 | 6007274.51894323 | 2119093.66115296 | 37.7990378895325 | -122.418925141627 | (37.7990378895325, -122.418925141627) | 5 | 1 | 10 | 28858 | 32 | ||
| 190071 | 25303 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | 9 | 7 | 6 | 28861 | 25 | |||
| 190049 | 191481 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012554.15249 | 2111142.66479 | 37.7775021925975 | -122.400097029578 | (37.7775021925975, -122.400097029578) | 14 | 2 | 9 | 28856 | 34 | |||
| 190046 | 227433 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4775 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999936.42251 | 2104608.30816 | 37.7588488908929 | -122.443276375017 | (37.7588488908929, -122.443276375017) | 2 | 4 | 5 | 28862 | 3 | |||
| 189914 | 207964 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 25 Stanford Heights Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997817.68344 | 2095709.5147 | 37.7342939366213 | -122.449962574511 | (37.7342939366213, -122.449962574511) | 9 | 7 | 4 | 59 | 40 | |||
| 189912 | 129563 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2270 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000463.82549 | 2119961.71511 | 37.8010354810636 | -122.442554716754 | (37.8010354810636, -122.442554716754) | 13 | 9 | 1 | 57 | 17 | |||
| 189896 | 17040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
| 189885 | 129645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 745 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008221.44348 | 2120654.50156 | 37.8033768408207 | -122.415759034171 | (37.8033768408207, -122.415759034171) | 5 | 1 | 10 | 308 | 32 | |||
| 189764 | 200059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | 10 | 3 | 8 | 58 | 1 | |||
| 189563 | 207906 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992324.52797 | 2098726.3849 | 37.7422616538593 | -122.46917350985 | (37.7422616538593, -122.46917350985) | 1 | 8 | 4 | 29491 | 40 | |||
| 189529 | 207999 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5999487.38528 | 2094945.27116 | 37.7322909017866 | -122.444135000045 | (37.7322909017866, -122.444135000045) | 9 | 7 | 4 | 63 | 40 | |||
| 189400 | 12214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693 | (37.735503845269, -122.38712984693) | 10 | 3 | 8 | 58 | 1 | |||
| 189395 | 227184 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 833 Ashbury St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999116.93208 | 2107411.40192 | 37.7664987220592 | -122.446312187656 | (37.7664987220592, -122.446312187656) | 15 | 5 | 11 | 29492 | 9 | |||
| 189357 | 246221 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 74 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999332.7614 | 2107891.6438 | 37.7678296695775 | -122.445600213463 | (37.7678296695775, -122.445600213463) | 15 | 5 | 11 | 29492 | 9 | |||
| 189349 | 246236 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 96 Delmar St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999346.6916 | 2107785.6536 | 37.7675394424612 | -122.445544408224 | (37.7675394424612, -122.445544408224) | 15 | 5 | 11 | 29492 | 9 | |||
| 189283 | 129675 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012092.09526 | 2116799.41386 | 37.7930085281603 | -122.402093232241 | (37.7930085281603, -122.402093232241) | 4 | 1 | 10 | 28854 | 6 | |||
| 189254 | 31669 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | 10 | 3 | 8 | 309 | 1 | |||
| 189252 | 207387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 337 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993441.47974 | 2105930.81218 | 37.7621076391783 | -122.465834809125 | (37.7621076391783, -122.465834809125) | 1 | 8 | 11 | 56 | 12 | |||
| 189251 | 20279 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | ||
| 189217 | 227393 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009249.42963 | 2104535.9463 | 37.7591768592327 | -122.411062434482 | (37.7591768592327, -122.411062434482) | 2 | 4 | 7 | 28859 | 19 | |||
| 189180 | 244908 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 141 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999866.5104 | 2109027.8153 | 37.7709797686818 | -122.443835682791 | (37.7709797686818, -122.443835682791) | 15 | 5 | 11 | 29492 | 9 | |||
| 189143 | 227492 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1708 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003946.47782 | 2098301.41143 | 37.7417594769116 | -122.428958089763 | (37.7417594769116, -122.428958089763) | 2 | 7 | 5 | 63 | 7 | |||
| 189076 | 227252 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6006140.42151 | 2096376.3293 | 37.7365975725045 | -122.421235477335 | (37.7365975725045, -122.421235477335) | 2 | 7 | 7 | 28859 | 2 | |||
| 188857 | 227488 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003985.98908 | 2109021.37679 | 37.7711962021697 | -122.429585829147 | (37.7711962021697, -122.429585829147) | 7 | 9 | 11 | 29492 | 10 | |||
| 188699 | 227329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998929.22815 | 2107043.77025 | 37.765478576097 | -122.446934961879 | (37.765478576097, -122.446934961879) | 15 | 5 | 11 | 29492 | 9 | |||
| 188685 | 227312 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 405 Beacon St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6002324.80027 | 2098291.20811 | 37.7416395352327 | -122.434564577593 | (37.7416395352327, -122.434564577593) | 2 | 7 | 5 | 63 | 7 | |||
| 188651 | 121996 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 626 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991310.91563 | 2111122.21398 | 37.7762386968182 | -122.473582239238 | (37.7762386968182, -122.473582239238) | 11 | 6 | 2 | 54 | 26 | |||
| 188622 | 227258 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6005985.64044 | 2096389.90351 | 37.7366261169846 | -122.421771586598 | (37.7366261169846, -122.421771586598) | 2 | 7 | 7 | 28859 | 2 | |||
| 188483 | 226698 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 30 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005180.26503 | 2107625.29214 | 37.7674304385828 | -122.425355413726 | (37.7674304385828, -122.425355413726) | 8 | 4 | 5 | 28853 | 19 | |||
| 188410 | 227352 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 20 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005581.68888 | 2097079.03604 | 37.7384955323317 | -122.42321719374 | (37.7384955323317, -122.42321719374) | 2 | 7 | 7 | 28859 | 2 | |||
| 188349 | 12174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016429.111 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | 10 | 3 | 8 | 58 | 1 | |||
| 188287 | 227466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 55 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999321.40182 | 2105445.36142 | 37.7611121418446 | -122.44546358288 | (37.7611121418446, -122.44546358288) | 15 | 5 | 5 | 28862 | 3 | |||
| 188267 | 20274 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
| 188215 | 207905 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991984.0362 | 2099641.46865 | 37.7447545592881 | -122.470417443113 | (37.7447545592881, -122.470417443113) | 1 | 8 | 4 | 29491 | 40 | |||
| 188173 | 129627 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2137 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006391.72079 | 2118062.38927 | 37.7961565285655 | -122.421906628814 | (37.7961565285655, -122.421906628814) | 13 | 9 | 10 | 28858 | 32 | |||
| 188156 | 227289 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 687 29th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6002191.96194 | 2098829.02358 | 37.7431087090925 | -122.435062343346 | (37.7431087090925, -122.435062343346) | 2 | 7 | 5 | 63 | 7 | ||||
| 188130 | 207990 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 171 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999635.15562 | 2095749.29461 | 37.7345069905129 | -122.443681865832 | (37.7345069905129, -122.443681865832) | 9 | 7 | 4 | 63 | 40 | |||
| 188077 | 207997 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999481.71143 | 2094946.11387 | 37.7322928919832 | -122.444154676308 | (37.7322928919832, -122.444154676308) | 9 | 7 | 4 | 63 | 40 | |||
| 188039 | 191488 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010222.32118 | 2110959.01545 | 37.7768676444492 | -122.408150691403 | (37.7768676444492, -122.408150691403) | 8 | 2 | 9 | 28853 | 34 | |||
| 188007 | 25290 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000711.5604 | 2091742.59446 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | 9 | 7 | 6 | 28861 | 25 | |||
| 187862 | 62716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.43148 | 2119179.891 | 37.7992927199273 | -122.417820789314 | (37.7992927199273, -122.417820789314) | 5 | 1 | 10 | 28858 | 32 | |
| 187677 | 141820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004741.7405 | 2112502.8158 | 37.7807981447488 | -122.427219682298 | (37.7807981447488, -122.427219682298) | 7 | 9 | 11 | 29490 | 41 | |||
| 187660 | 244053 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Cole St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997903.1431 | 2109164.16 | 37.7712419510675 | -122.450636826227 | (37.7712419510675, -122.450636826227) | 15 | 5 | 11 | 29492 | 9 | |||
| 187619 | 207996 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.7322936186354 | -122.44417699929 | (37.7322936186354, -122.44417699929) | 9 | 7 | 4 | 63 | 40 |
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) );