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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23385 | 23385 | 225339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3033 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6002890.27268 | 2096019.3333400001 | 37.73543357459229 | -122.43244713645001 | (37.7354335745923, -122.43244713645) | |||
| 19931 | 19931 | 5118 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2721 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6002423.4063 | 2096112.9381400002 | 37.735664106798794 | -122.434067955786 | (37.7356641067988, -122.434067955786) | |||
| 184543 | 184543 | 190147 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1779 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6014086.91592 | 2096161.3787200002 | 37.7364521575355 | -122.393745786146 | (37.7364521575355, -122.393745786146) | |||
| 37303 | 37303 | 224913 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 125 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005373.442559999 | 2096202.2460599998 | 37.7360763092684 | -122.423874880523 | (37.7360763092684, -122.423874880523) | |||
| 177556 | 177556 | 224912 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005313.574630001 | 2096207.88918 | 37.7360884240317 | -122.42408226958901 | (37.7360884240317, -122.424082269589) | |||
| 24172 | 24172 | 224911 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Richland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005275.2248599995 | 2096215.80482 | 37.7361079932903 | -122.424215423207 | (37.7361079932903, -122.424215423207) | |||
| 121408 | 121408 | 51678 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 672 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | Permit Number 770377 | 6007616.9101817 | 2096263.07678619 | 37.7363697350759 | -122.41612259019199 | (37.7363697350759, -122.416122590192) | |||
| 158159 | 158159 | 224885 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 Laidley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003400.611930001 | 2096293.5067900002 | 37.7362153183682 | -122.430702261917 | (37.7362153183682, -122.430702261917) | |||
| 44233 | 44233 | 218913 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994999.9662 | 2096306.6949200002 | 37.7357720155706 | -122.45974750415701 | (37.7357720155706, -122.459747504157) | |||
| 65593 | 65593 | 224884 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6003425.22105 | 2096310.9905700001 | 37.7362647190293 | -122.43061842530899 | (37.7362647190293, -122.430618425309) | |||
| 42794 | 42794 | 224883 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003443.08851 | 2096324.3523 | 37.7363024195061 | -122.430557603265 | (37.7363024195061, -122.430557603265) | |||
| 187097 | 187097 | 218914 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994998.52296 | 2096325.6672900002 | 37.7358240260431 | -122.459753867773 | (37.7358240260431, -122.459753867773) | |||
| 162523 | 162523 | 218915 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994994.9518099995 | 2096345.60067 | 37.735878552841896 | -122.459767657962 | (37.7358785528419, -122.459767657962) | |||
| 182344 | 182344 | 224882 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 470 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003486.83593 | 2096359.1956900002 | 37.736400569720395 | -122.430408835608 | (37.7364005697204, -122.430408835608) | |||
| 173825 | 173825 | 218951 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994989.40936 | 2096384.24367 | 37.7359843382934 | -122.45978961850099 | (37.7359843382934, -122.459789618501) | |||
| 186495 | 186495 | 218950 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994983.41019 | 2096409.8604700002 | 37.7360543307295 | -122.45981221488701 | (37.7360543307295, -122.459812214887) | |||
| 54865 | 54865 | 224915 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 127 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005663.14578 | 2096418.24956 | 37.736685757338904 | -122.42288860482999 | (37.7366857573389, -122.42288860483) | |||
| 151083 | 151083 | 224914 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 125 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005639.35465 | 2096421.45369 | 37.73669321271311 | -122.42297108883801 | (37.7366932127131, -122.422971088838) | |||
| 32016 | 32016 | 224887 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 204 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001690.70121 | 2096422.54487 | 37.7364726045189 | -122.43662334968599 | (37.7364726045189, -122.436623349686) | |||
| 132528 | 132528 | 218949 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994976.21995 | 2096430.6206900002 | 37.7361109196879 | -122.45983857761499 | (37.7361109196879, -122.459838577615) | |||
| 154326 | 154326 | 224888 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 204 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001640.90489 | 2096431.2479299998 | 37.736493671139 | -122.436796139152 | (37.736493671139, -122.436796139152) | |||
| 130680 | 130680 | 218948 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994974.326309999 | 2096444.2195099997 | 37.7361481498027 | -122.459846109406 | (37.7361481498027, -122.459846109406) | |||
| 53207 | 53207 | 192168 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1516 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 6015644.07634 | 2096462.96533 | 37.737366661932995 | -122.38838302088301 | (37.737366661933, -122.388383020883) | |||
| 157803 | 157803 | 218947 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994959.84342 | 2096480.8612099998 | 37.7362479259859 | -122.45989883578899 | (37.7362479259859, -122.459898835789) | |||
| 88593 | 88593 | 104720 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002455.5 | 2096493.1 | 37.7367097651894 | -122.43398416151399 | (37.7367097651894, -122.433984161514) | ||||
| 14046 | 14046 | 15032 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015793.96455 | 2096498.2238200002 | 37.7374717791904 | -122.387867242574 | (37.7374717791904, -122.387867242574) | |||
| 16456 | 16456 | 15031 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015804.02925 | 2096508.49114 | 37.7375005287238 | -122.38783316007 | (37.7375005287238, -122.38783316007) | |||
| 16439 | 16439 | 54186 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1536 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 20 | 3x3 | Permit Number 9921 | 6015571.57326 | 2096517.43556 | 37.7375122082315 | -122.388637501128 | (37.7375122082315, -122.388637501128) | |
| 13666 | 13666 | 15030 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015814.843090001 | 2096523.3244599998 | 37.737541857055604 | -122.387796805884 | (37.7375418570556, -122.387796805884) | |||
| 124459 | 124459 | 104719 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 61- 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 771137 | 6002409.7 | 2096544.3 | 37.7368477492981 | -122.434146170859 | (37.7368477492981, -122.434146170859) | |||
| 160032 | 160032 | 190133 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Phelps St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6014167.590919999 | 2096559.46483 | 37.73754970274621 | -122.39349470802401 | (37.7375497027462, -122.393494708024) | |||
| 23125 | 23125 | 15028 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6015848.122169999 | 2096570.1490599997 | 37.737672271366 | -122.387685009354 | (37.737672271366, -122.387685009354) | |||
| 23208 | 23208 | 6749 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1215 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6017498.178719999 | 2096747.56806 | 37.738250691012205 | -122.381992253155 | (37.7382506910122, -122.381992253155) | |||
| 23319 | 23319 | 6750 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1215 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6017497.29462 | 2096749.0937700002 | 37.7382548314821 | -122.381995416066 | (37.7382548314821, -122.381995416066) | |||
| 36578 | 36578 | 225341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 120 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002714.46502 | 2096770.94289 | 37.73748735096461 | -122.433108653456 | (37.7374873509646, -122.433108653456) | |||
| 35490 | 35490 | 192167 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 818 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6016012.76751 | 2096784.5302 | 37.738270037232205 | -122.387130695121 | (37.7382700372322, -122.387130695121) | |||
| 132668 | 132668 | 225340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6002661.94907 | 2096787.4859799999 | 37.737529795366605 | -122.43329140736999 | (37.7375297953666, -122.43329140737) | |||
| 127537 | 127537 | 105037 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770444 | 6001403.1 | 2096820.4 | 37.7375486740807 | -122.437646191192 | (37.7375486740807, -122.437646191192) | |||
| 188701 | 188701 | 224871 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 243 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004648.05495 | 2096912.1028200001 | 37.7379844377336 | -122.42643336811001 | (37.7379844377336, -122.42643336811) | |||
| 155209 | 155209 | 190144 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1270 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6017331.65483 | 2096956.7216900003 | 37.738815787225796 | -122.382582565458 | (37.7388157872258, -122.382582565458) | |||
| 120086 | 120086 | 189055 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1270 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6017298.65982 | 2096980.57474 | 37.7388794601286 | -122.38269830729601 | (37.7388794601286, -122.382698307296) | |||
| 36986 | 36986 | 190145 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1270 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6017279.69898 | 2096994.64423 | 37.7389170445949 | -122.38276484453002 | (37.7389170445949, -122.38276484453) | |||
| 13448 | 13448 | 59987 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1546 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19471 | 6015827.92235 | 2097026.6864599998 | 37.738924711310794 | -122.387786695709 | (37.7389247113108, -122.387786695709) | ||
| 56535 | 56535 | 189056 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1298 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6017215.97894 | 2097042.62645 | 37.739045273523104 | -122.38298849961201 | (37.7390452735231, -122.382988499612) | |||
| 71355 | 71355 | 190146 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1298 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6017196.21156 | 2097055.6209099998 | 37.739079861441496 | -122.38305775101601 | (37.7390798614415, -122.383057751016) | |||
| 129554 | 129554 | 59986 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1552 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1982 12:00:00 AM | 19 | 3x3 | Permit Number 19470 | 6015757.2015 | 2097078.5324799998 | 37.7390631520541 | -122.388034834851 | (37.7390631520541, -122.388034834851) | |
| 159595 | 159595 | 60020 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1575 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1982 12:00:00 AM | 15 | Permit Number 19507 | 6015654.8886400005 | 2097084.06623 | 37.739072677666705 | -122.38838897527799 | (37.7390726776667, -122.388388975278) | ||
| 33257 | 33257 | 59984 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1562 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19468 | 6015739.3496 | 2097091.61317 | 37.7390980799033 | -122.38809747171899 | (37.7390980799033, -122.388097471719) | ||
| 172312 | 172312 | 190134 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 599 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011052.12686 | 2097137.70773 | 37.738963838104205 | -122.404307086999 | (37.7389638381042, -122.404307086999) | |||
| 69514 | 69514 | 225342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2409 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001890.8012 | 2097157.51545 | 37.7385020326503 | -122.435984095409 | (37.7385020326503, -122.435984095409) | |||
| 154576 | 154576 | 190132 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011496.4373 | 2097233.7856099997 | 37.7392524656321 | -122.402777612703 | (37.7392524656321, -122.402777612703) | |||
| 44383 | 44383 | 31033 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 14 | Permit Number 34795 | 6007165.73364 | 2097244.81594 | 37.7390399953959 | -122.417752065831 | (37.7390399953959, -122.417752065831) | ||
| 42599 | 42599 | 190131 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6011654.92131 | 2097288.97497 | 37.7394128516087 | -122.402233521954 | (37.7394128516087, -122.402233521954) | |||
| 51824 | 51824 | 190130 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6011690.7758 | 2097300.73442 | 37.7394471418669 | -122.40211037869301 | (37.7394471418669, -122.402110378693) | |||
| 14914 | 14914 | 6792 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016736.55231 | 2097315.7132900003 | 37.739768612644 | -122.384665171383 | (37.739768612644, -122.384665171383) | |||
| 58659 | 58659 | 190129 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011744.4272 | 2097318.12593 | 37.739497889703 | -122.401926096826 | (37.739497889703, -122.401926096826) | |||
| 15509 | 15509 | 6804 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x9 | 6016716.56136 | 2097329.28644 | 37.7398047761739 | -122.384735237561 | (37.7398047761739, -122.384735237561) | |||
| 72432 | 72432 | 190142 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1385 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6016719.34934 | 2097329.5303 | 37.7398055999553 | -122.384725614793 | (37.7398055999553, -122.384725614793) | |||
| 106243 | 106243 | 101891 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 196X Wool St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 21188 | 6007299.5 | 2097331.3 | 37.739284988220795 | -122.41729568877899 | (37.7392849882208, -122.417295688779) | ||||
| 157888 | 157888 | 190136 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 78 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | 6011218.70135 | 2097332.49038 | 37.739507976518105 | -122.40374484797199 | (37.7395079765181, -122.403744847972) | ||||
| 61191 | 61191 | 190128 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6011796.42353 | 2097334.30265 | 37.7395452093339 | -122.40174745189199 | (37.7395452093339, -122.401747451892) | |||
| 16261 | 16261 | 6803 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016702.460969999 | 2097342.51463 | 37.7398403182643 | -122.384784912507 | (37.7398403182643, -122.384784912507) | |||
| 14817 | 14817 | 6802 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6016686.26757 | 2097353.7409 | 37.739870247704204 | -122.384841684893 | (37.7398702477042, -122.384841684893) | |||
| 62875 | 62875 | 190141 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1385 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6016685.94194 | 2097355.07165 | 37.7398738836642 | -122.384842903479 | (37.7398738836642, -122.384842903479) | |||
| 157342 | 157342 | 224894 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 261 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007913.51531 | 2097415.81072 | 37.7395515621515 | -122.415178671966 | (37.7395515621515, -122.415178671966) | |||
| 52599 | 52599 | 224895 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 255 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007913.53154 | 2097436.63172 | 37.7396087329441 | -122.41518008930599 | (37.7396087329441, -122.415180089306) | |||
| 157182 | 157182 | 224896 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 243 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008635.61121 | 2097449.96485 | 37.7396858965836 | -122.4126843825 | (37.7396858965836, -122.4126843825) | |||
| 50857 | 50857 | 189057 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1398 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6016659.73338 | 2097454.68952 | 37.7401459645668 | -122.384940461042 | (37.7401459645668, -122.384940461042) | |||
| 129824 | 129824 | 224845 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 244 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007886.5732 | 2097457.36485 | 37.7396641464798 | -122.41527476721501 | (37.7396641464798, -122.415274767215) | |||
| 101618 | 101618 | 57859 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 243 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16802 | 6008653.70601919 | 2097500.21669417 | 37.7398248927239 | -122.412625369635 | (37.7398248927239, -122.412625369635) | |||
| 171588 | 171588 | 225344 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 207 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004214.46195 | 2097518.65353 | 37.7396253677099 | -122.42797572341999 | (37.7396253677099, -122.42797572342) | |||
| 180529 | 180529 | 190135 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2160x Palou Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011839.17334 | 2097531.5367900003 | 37.7400891579846 | -122.40161349967899 | (37.7400891579846, -122.401613499679) | ||||
| 52470 | 52470 | 189048 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2160x Palou Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6011828.04798 | 2097532.87353 | 37.7400922075757 | -122.40165206078699 | (37.7400922075757, -122.401652060787) | ||||
| 132150 | 132150 | 224846 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 228 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007895.756130001 | 2097553.2208 | 37.7399278618879 | -122.415249800251 | (37.7399278618879, -122.415249800251) | |||
| 50687 | 50687 | 225349 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 204 Addison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002618.3825900005 | 2097557.08683 | 37.739640470019104 | -122.433497019365 | (37.7396404700191, -122.433497019365) | |||
| 185656 | 185656 | 225326 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 130 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.98377 | 2097574.34607 | 37.7398065343366 | -122.426252554911 | (37.7398065343366, -122.426252554911) | |||
| 163919 | 163919 | 189049 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2160x Palou Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011843.03345 | 2097575.14074 | 37.7402091005685 | -122.401603216821 | (37.7402091005685, -122.401603216821) | ||||
| 42662 | 42662 | 190140 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1401 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6016375.816219999 | 2097583.85317 | 37.740484913635605 | -122.385931141602 | (37.7404849136356, -122.385931141602) | |||
| 167734 | 167734 | 246685 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6004978.8033300005 | 2097597.3431 | 37.7398846440669 | -122.425338555951 | (37.7398846440669, -122.425338555951) | |||
| 188592 | 188592 | 246684 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6004997.42528 | 2097597.83608 | 37.73988704974779 | -122.425274204056 | (37.7398870497478, -122.425274204056) | |||
| 27960 | 27960 | 246686 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6004961.87116 | 2097597.9446799997 | 37.7398853392354 | -122.425397143159 | (37.7398853392354, -122.425397143159) | |||
| 127240 | 127240 | 246683 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6005013.28889 | 2097598.95016 | 37.7398910049652 | -122.425219433535 | (37.7398910049652, -122.425219433535) | |||
| 60834 | 60834 | 246682 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6005028.19634 | 2097600.03774 | 37.7398948333787 | -122.42516796712799 | (37.7398948333787, -122.425167967128) | |||
| 131872 | 131872 | 225327 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1893 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6004623.32854 | 2097601.54751 | 37.7398760987005 | -122.42656793905199 | (37.7398760987005, -122.426567939052) | |||
| 166371 | 166371 | 246687 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 6004944.1218 | 2097602.36636 | 37.7398964773322 | -122.42545882766301 | (37.7398964773322, -122.425458827663) | |||
| 152152 | 152152 | 246681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6005137.38612 | 2097606.83226 | 37.7399196573536 | -122.42479091738701 | (37.7399196573536, -122.424790917387) | |||
| 184951 | 184951 | 246679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005202.46496 | 2097607.42576 | 37.739924962478796 | -122.42456594386101 | (37.7399249624788, -122.424565943861) | |||
| 147841 | 147841 | 246680 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6005184.39895 | 2097607.58215 | 37.7399243716053 | -122.42462841978201 | (37.7399243716053, -122.424628419782) | |||
| 152345 | 152345 | 246678 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6005222.8012 | 2097609.38503 | 37.7399314906489 | -122.424495768869 | (37.7399314906489, -122.424495768869) | |||
| 186943 | 186943 | 246677 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 25 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6005248.94304 | 2097610.63078 | 37.7399363874552 | -122.424405469757 | (37.7399363874552, -122.424405469757) | ||||
| 153949 | 153949 | 246676 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 25 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6005260.167640001 | 2097612.18333 | 37.739941284250996 | -122.42436677011601 | (37.739941284251, -122.424366770116) | ||||
| 14941 | 14941 | 6814 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016451.12132 | 2097615.70854 | 37.7405765491786 | -122.38567298313801 | (37.7405765491786, -122.385672983138) | |||
| 185886 | 185886 | 225328 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1893 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004620.6476 | 2097622.71658 | 37.7399340725935 | -122.42657871563401 | (37.7399340725935, -122.426578715634) | |||
| 76606 | 76606 | 246675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6005283.663509999 | 2097689.92499 | 37.7401560720365 | -122.424291058881 | (37.7401560720365, -122.424291058881) | |||
| 15881 | 15881 | 6819 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016343.96785 | 2097693.33127 | 37.7407837556653 | -122.386048891651 | (37.7407837556653, -122.386048891651) | |||
| 48262 | 48262 | 246674 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 8ft | 6005286.18809 | 2097704.16876 | 37.740195324763704 | -122.424283342697 | (37.7401953247637, -122.424283342697) | |||
| 132636 | 132636 | 246673 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 8ft | 6005263.852999999 | 2097708.23975 | 37.740205241579396 | -122.424360857976 | (37.7402052415794, -122.424360857976) | |||
| 37960 | 37960 | 246672 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6005247.4068 | 2097710.7023400003 | 37.7402110745895 | -122.42441789747299 | (37.7402110745895, -122.424417897473) | |||
| 53058 | 53058 | 225345 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003063.3105 | 2097714.60702 | 37.7400982177717 | -122.43196989589599 | (37.7400982177717, -122.431969895896) | |||
| 44299 | 44299 | 225346 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Beacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003056.678169999 | 2097724.21809 | 37.740124231553104 | -122.431993513899 | (37.7401242315531, -122.431993513899) |
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");