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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183117 | 183117 | 246173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.45062241217899 | (37.768712864196, -122.450622412179) | |||
| 131916 | 131916 | 248363 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1503 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998433.2076 | 2108248.225 | 37.7687573531744 | -122.44873733691401 | (37.7687573531744, -122.448737336914) | |||
| 27278 | 27278 | 248364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.768773410658895 | -122.44862143957701 | (37.7687734106589, -122.448621439577) | |||
| 177206 | 177206 | 246136 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1556 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998150.3653 | 2108253.3731 | 37.768755310607 | -122.449716033907 | (37.768755310607, -122.449716033907) | |||
| 133245 | 133245 | 246094 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | |||
| 68809 | 68809 | 248358 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998577.0515 | 2108268.5146 | 37.76882128769329 | -122.44824125490601 | (37.7688212876933, -122.448241254906) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 173043 | 173043 | 248359 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998647.9135 | 2108278.8108 | 37.768853609287206 | -122.44799689076099 | (37.7688536092872, -122.447996890761) | |||
| 27737 | 27737 | 248360 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998667.1431 | 2108281.3848 | 37.768861776014795 | -122.447930562543 | (37.7688617760148, -122.447930562543) | |||
| 122024 | 122024 | 248318 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998789.7889 | 2108283.5046 | 37.768874606083 | -122.447506493604 | (37.768874606083, -122.447506493604) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 154687 | 154687 | 246093 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997094.8545 | 2108310.1536 | 37.7688507707463 | -122.453371047271 | (37.7688507707463, -122.453371047271) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 189100 | 189100 | 246130 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998621.8702 | 2108319.087 | 37.768962708792 | -122.448089872703 | (37.768962708792, -122.448089872703) | |||
| 39181 | 39181 | 246129 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998642.4625 | 2108323.3267 | 37.768975527056206 | -122.44801895087299 | (37.7689755270562, -122.448018950873) | |||
| 160330 | 160330 | 246074 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998681.2247 | 2108328.1719 | 37.7689910464057 | -122.447885224354 | (37.7689910464057, -122.447885224354) | |||
| 38494 | 38494 | 246056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1466 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998693.9435 | 2108329.3832 | 37.7689950993057 | -122.44784131823401 | (37.7689950993057, -122.447841318234) | |||
| 62338 | 62338 | 246145 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998507.7036 | 2108329.6861 | 37.768985284301706 | -122.448485529275 | (37.7689852843017, -122.448485529275) | |||
| 187956 | 187956 | 246092 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997091.8262 | 2108330.4431 | 37.7689063069149 | -122.45338298694901 | (37.7689063069149, -122.453382986949) | |||
| 51484 | 51484 | 246055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998722.7122 | 2108332.1087 | 37.7690042271302 | -122.447742005772 | (37.7690042271302, -122.447742005772) | |||
| 30721 | 30721 | 246053 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | |||
| 136566 | 136566 | 246132 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998549.1912 | 2108336.0455 | 37.7690051176051 | -122.448342484944 | (37.7690051176051, -122.448342484944) | |||
| 39156 | 39156 | 248312 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999157.272000001 | 2108349.6728 | 37.769077281031606 | -122.44624016016199 | (37.7690772810316, -122.446240160162) | |||
| 161629 | 161629 | 246091 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997087.5866 | 2108354.0638 | 37.7689709202682 | -122.45339935697099 | (37.7689709202682, -122.453399356971) | |||
| 150342 | 150342 | 246133 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998546.7685 | 2108359.3633 | 37.7690690038469 | -122.44835254426701 | (37.7690690038469, -122.448352544267) | |||
| 168121 | 168121 | 248309 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1333 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999321.5567 | 2108373.142 | 37.769151102475 | -122.445673599246 | (37.769151102475, -122.445673599246) | |||
| 38816 | 38816 | 246090 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997084.5583 | 2108373.7477 | 37.769024793611 | -122.45341125296001 | (37.769024793611, -122.45341125296) | |||
| 172304 | 172304 | 248308 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1327 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999347.2972 | 2108376.4732 | 37.76916171869029 | -122.445584804207 | (37.7691617186903, -122.445584804207) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 21249 | 21249 | 15334 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | ||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 1169 | 1169 | 246080 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17683 | 5999123.3551 | 2108389.3434 | 37.7691842694065 | -122.446360330481 | (37.7691842694065, -122.446360330481) | |
| 156171 | 156171 | 246039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1378 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999138.4966 | 2108392.6745 | 37.7691942805388 | -122.446308196721 | (37.7691942805388, -122.446308196721) | |||
| 183831 | 183831 | 246038 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1378 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999156.0607 | 2108395.7028 | 37.7692035985916 | -122.446247661551 | (37.7692035985916, -122.446247661551) | |||
| 169792 | 169792 | 246387 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | |||
| 62593 | 62593 | 246085 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 668 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999025.5413 | 2108408.7245 | 37.769231898011896 | -122.44670005643101 | (37.7692318980119, -122.446700056431) | |||
| 173968 | 173968 | 246089 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | |||
| 21803 | 21803 | 15326 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006681.5676 | 2108466.3283 | 37.769824429915204 | -122.420222300021 | (37.7698244299152, -122.420222300021) | |||
| 108810 | 108810 | 113054 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003823.0 | 2108493.0 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | ||||
| 35453 | 35453 | 246043 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997853.8956 | 2108495.9392 | 37.7694043689932 | -122.450758987128 | (37.7694043689932, -122.450758987128) | |||
| 20349 | 20349 | 10509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1792 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997587.0634 | 2108527.2635 | 37.7694750996845 | -122.45168420313499 | (37.7694750996845, -122.451684203135) | |||
| 21538 | 21538 | 10477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | |||
| 23341 | 23341 | 10463 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.44841959455401 | (37.7698923436585, -122.448419594554) | |||
| 2207 | 2207 | 244533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1588 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 5998589.1758 | 2108666.333 | 37.7699142890018 | -122.448227967728 | (37.7699142890018, -122.448227967728) | |||
| 18240 | 18240 | 14585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918002 | (37.7700327707282, -122.44520049918) | |||
| 22044 | 22044 | 15319 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1680 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006779.4102 | 2108712.5677 | 37.77050605746361 | -122.41990134010099 | (37.7705060574636, -122.419901340101) | |||
| 26187 | 26187 | 244530 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258946998 | (37.7701388371467, -122.44703258947) | |||
| 184456 | 184456 | 244529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 564 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998978.8238 | 2108751.0336 | 37.7701691232136 | -122.446886284448 | (37.7701691232136, -122.446886284448) | |||
| 18241 | 18241 | 10403 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.77021559548189 | -122.44475781986999 | (37.7702155954819, -122.44475781987) | |||
| 135352 | 135352 | 244193 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998442.5226 | 2108797.1780000003 | 37.7702651709945 | -122.44874466162099 | (37.7702651709945, -122.448744661621) | |||
| 59210 | 59210 | 244027 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 510 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998001.7833 | 2108800.966 | 37.7702503589654 | -122.45026944288 | (37.7702503589654, -122.45026944288) | |||
| 50460 | 50460 | 244192 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998441.2408 | 2108808.2865 | 37.7702955988047 | -122.448749895574 | (37.7702955988047, -122.448749895574) | |||
| 52833 | 52833 | 244023 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997999.7197 | 2108815.8239 | 37.7702910368595 | -122.45027765199801 | (37.7702910368595, -122.450277651998) | |||
| 17194 | 17194 | 5146 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | |||
| 177244 | 177244 | 247347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999077.9485 | 2109033.7671 | 37.7709511000472 | -122.44656375893899 | (37.7709511000472, -122.446563758939) | |||
| 72403 | 72403 | 247348 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999102.728999999 | 2109036.7578 | 37.7709607271706 | -122.44647825803001 | (37.7709607271706, -122.44647825803) | |||
| 17307 | 17307 | 15307 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.771434887034104 | -122.419572183108 | (37.7714348870341, -122.419572183108) | ||
| 42222 | 42222 | 244167 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 443 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997917.5884 | 2109065.1071 | 37.7709708040394 | -122.450579717232 | (37.7709708040394, -122.450579717232) | |||
| 52857 | 52857 | 244541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1520 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999127.722999999 | 2109084.8233 | 37.7710941303807 | -122.44639526179701 | (37.7710941303807, -122.446395261797) | |||
| 152752 | 152752 | 247257 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997008.9956 | 2109086.9596 | 37.7709787579671 | -122.45372412669902 | (37.7709787579671, -122.453724126699) | |||
| 73607 | 73607 | 247258 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2089 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997028.4355 | 2109091.0184 | 37.7709910168471 | -122.453657177015 | (37.7709910168471, -122.453657177015) | |||
| 17505 | 17505 | 20093 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2079X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997064.7516 | 2109095.7182 | 37.7710060031357 | -122.453531898634 | (37.7710060031357, -122.453531898634) | |||
| 21742 | 21742 | 20094 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2075X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997081.4143 | 2109098.2817 | 37.7710139970036 | -122.453474447283 | (37.7710139970036, -122.453474447283) | |||
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 21345 | 21345 | 17138 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2049 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997189.9355 | 2109110.6719 | 37.771054237387396 | -122.453099965702 | (37.7710542373874, -122.453099965702) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 21485 | 21485 | 17133 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | |||
| 21783 | 21783 | 17132 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2017 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997337.3364 | 2109131.1798 | 37.7711189934376 | -122.45259158414301 | (37.7711189934376, -122.452591584143) | |||
| 21113 | 21113 | 17130 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997372.7981 | 2109137.1613 | 37.7711374488605 | -122.45246935322399 | (37.7711374488605, -122.452469353224) | |||
| 19705 | 19705 | 17131 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997393.7333 | 2109140.5793 | 37.771148033222794 | -122.452397184671 | (37.7711480332228, -122.452397184671) | |||
| 18803 | 18803 | 17128 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | ||
| 18301 | 18301 | 17129 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997503.109 | 2109154.2513 | 37.7711918386222 | -122.452019838592 | (37.7711918386222, -122.452019838592) | |||
| 17644 | 17644 | 17126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.45172820804599 | (37.7712342233691, -122.451728208046) | |||
| 21861 | 21861 | 17124 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1959 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997650.0826 | 2109175.1865 | 37.7712577387998 | -122.451512964016 | (37.7712577387998, -122.451512964016) | |||
| 21140 | 21140 | 28785 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | |||
| 22051 | 22051 | 28786 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002265.8749 | 2109178.7673 | 37.7715308120493 | -122.43554702410299 | (37.7715308120493, -122.435547024103) | |||
| 17174 | 17174 | 17123 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1949 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997679.9901 | 2109179.4590000003 | 37.7712711825876 | -122.451409821439 | (37.7712711825876, -122.451409821439) | |||
| 19773 | 19773 | 17120 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1931 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997753.4769 | 2109191.4219 | 37.7713082373467 | -122.45115649157499 | (37.7713082373467, -122.451156491575) | |||
| 72703 | 72703 | 244544 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1921 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997795.9759 | 2109196.9758 | 37.7713259200895 | -122.451009886929 | (37.7713259200895, -122.451009886929) | |||
| 135750 | 135750 | 247391 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 215 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002287.9227 | 2109197.4231 | 37.7715832884679 | -122.435472094457 | (37.7715832884679, -122.435472094457) | |||
| 18594 | 18594 | 17117 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1907 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997844.0536 | 2109200.8214 | 37.771339231452 | -122.45084386213101 | (37.771339231452, -122.450843862131) | |||
| 166904 | 166904 | 244543 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1901 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997870.5431 | 2109205.9484 | 37.7713548252376 | -122.45075260390301 | (37.7713548252376, -122.450752603903) | |||
| 19201 | 19201 | 15302 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006948.3596 | 2109215.1279 | 37.7718954850631 | -122.419352599105 | (37.7718954850631, -122.419352599105) | |||
| 170504 | 170504 | 245138 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1320 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000087.6508 | 2109218.0834 | 37.7715148081993 | -122.443084420904 | (37.7715148081993, -122.443084420904) | |||
| 19853 | 19853 | 17115 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997963.2561 | 2109219.1931 | 37.7713964984716 | -122.450432861809 | (37.7713964984716, -122.450432861809) | |||
| 21997 | 21997 | 17116 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.771406934874896 | -122.450369559944 | (37.7714069348749, -122.450369559944) | |||
| 17479 | 17479 | 17114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998005.981000001 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | |||
| 186591 | 186591 | 247390 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 217 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002281.8171 | 2109227.9509 | 37.7716667634841 | -122.43549539828501 | (37.7716667634841, -122.435495398285) | |||
| 18214 | 18214 | 17113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.45011157971099 | (37.7714358490518, -122.450111579711) | |||
| 21535 | 21535 | 15301 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006957.7934 | 2109234.853 | 37.7719501768124 | -122.41932136637399 | (37.7719501768124, -122.419321366374) | |||
| 17820 | 17820 | 17112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1855 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998114.9295 | 2109242.2645 | 37.7714685261947 | -122.449909881636 | (37.7714685261947, -122.449909881636) | |||
| 18957 | 18957 | 15300 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006966.3695 | 2109250.29 | 37.7719930461457 | -122.41929279621 | (37.7719930461457, -122.41929279621) | |||
| 135005 | 135005 | 247389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 219 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002278.4252 | 2109251.0163 | 37.771729902717794 | -122.43550878138001 | (37.7717299027178, -122.43550878138) | |||
| 21019 | 21019 | 15299 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006975.8032 | 2109269.1574 | 37.7720453828325 | -122.41926150288602 | (37.7720453828325, -122.419261502886) | |||
| 17018 | 17018 | 4509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.44919964223699 | (37.7715600792218, -122.449199642237) |
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");