Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCareAssistant, PlantDate
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119 | 119 | 251215 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | ||||
| 746 | 746 | 251371 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 786 | 786 | 251369 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 939 | 939 | 13046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.41041331411199 | (37.8032072253646, -122.410413314112) | |||
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 1579 | 1579 | 588 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | |||
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 2585 | 2585 | 6246 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | |||
| 3424 | 3424 | 13006 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | ||
| 3698 | 3698 | 20141 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | |||
| 3917 | 3917 | 253597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010453.0 | 2107072.0 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | ||||
| 4268 | 4268 | 2729 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | |||
| 4346 | 4346 | 12986 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.40686916312401 | (37.8036540726688, -122.406869163124) | ||
| 4532 | 4532 | 253201 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4541 | 4541 | 253199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 4562 | 4562 | 253642 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.40823488063499 | (37.7988770104459, -122.408234880635) | ||||
| 5314 | 5314 | 12245 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004995.5845 | 2110652.4736 | 37.775731910957106 | -122.426209740207 | (37.7757319109571, -122.426209740207) | ||
| 5440 | 5440 | 13266 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.44206111460501 | (37.7991775301158, -122.442061114605) | ||
| 5465 | 5465 | 7223 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | |||
| 6433 | 6433 | 13039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | |||
| 6631 | 6631 | 13008 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.803418967602205 | -122.40768869648399 | (37.8034189676022, -122.407688696484) | ||
| 7836 | 7836 | 13005 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | ||
| 8687 | 8687 | 13035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:33:00 AM | 3 | 3X3 | 6010007.9078 | 2120594.4895 | 37.8033123274611 | -122.40957264178199 | (37.8033123274611, -122.409572641782) | ||
| 8862 | 8862 | 13007 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.40778071851601 | (37.8034055135257, -122.407780718516) | ||
| 9938 | 9938 | 27712 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 10210 | 10210 | 173906 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6005854.79213 | 2118988.3638299997 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | |||||
| 17596 | 17596 | 17025 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.772991052563704 | -122.43798896281 | (37.7729910525637, -122.43798896281) | |||
| 18408 | 18408 | 17037 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | |||
| 19024 | 19024 | 4603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | |||
| 19352 | 19352 | 20113 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002934.0 | 2109937.0 | 37.773650656395205 | -122.43329013413602 | (37.7736506563952, -122.433290134136) | |||
| 19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 20099 | 20099 | 615 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008105.608030001 | 2102127.9045700002 | 37.752500715042295 | -122.414847903135 | (37.7525007150423, -122.414847903135) | |||
| 20379 | 20379 | 9943 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 20740 | 20740 | 16969 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 770 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003329.8686 | 2110020.1015 | 37.773901282351105 | -122.431926699871 | (37.7739012823511, -122.431926699871) | |||
| 20818 | 20818 | 603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.752462191692295 | -122.413639440921 | (37.7524621916923, -122.413639440921) | |||
| 21788 | 21788 | 17003 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | |||
| 27180 | 27180 | 21626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.69671 | 2114745.4452299997 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | |||
| 34299 | 34299 | 16935 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | |||
| 44578 | 44578 | 17305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | |||
| 46254 | 46254 | 23132 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | ||
| 51508 | 51508 | 7237 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | |||
| 58954 | 58954 | 11429 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016007.44377 | 2096780.4211400002 | 37.738258459777605 | -122.38714881562599 | (37.7382584597776, -122.387148815626) | |||
| 63413 | 63413 | 16731 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | |||
| 77387 | 77387 | 109858 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5x8 | 6015836.2 | 2104173.0 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | |||
| 77413 | 77413 | 94294 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 77711 | 77711 | 484 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.40670053704201 | (37.7532507356841, -122.406700537042) | |||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 77911 | 77911 | 16945 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | |||
| 77916 | 77916 | 11109 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | |||
| 78039 | 78039 | 7891 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | |||
| 78051 | 78051 | 18469 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6010532.642999999 | 2102160.24981 | 37.752725602318705 | -122.406457044136 | (37.7527256023187, -122.406457044136) | |||
| 78224 | 78224 | 7218 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 78246 | 78246 | 23492 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005839.2618 | 2119053.8946700003 | 37.798847779282106 | -122.423888789861 | (37.7988477792821, -122.423888789861) | |||
| 78264 | 78264 | 525 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009855.900330001 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | |||
| 78647 | 78647 | 9661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006079.1393099995 | 2110176.8838400003 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | |||
| 78758 | 78758 | 12942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | |||
| 78830 | 78830 | 17674 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002359.74374 | 2112046.46454 | 37.7794101245475 | -122.435427501131 | (37.7794101245475, -122.435427501131) | |||
| 78900 | 78900 | 9577 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | |||
| 78901 | 78901 | 23814 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 78920 | 78920 | 23703 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 78939 | 78939 | 8182 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | |||
| 78965 | 78965 | 11046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007462.427490001 | 2117742.7343900003 | 37.795339161156605 | -122.41817908492399 | (37.7953391611566, -122.418179084924) | |||
| 79031 | 79031 | 4709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.6629099995 | 2120633.4675 | 37.8033402849031 | -122.41445215852801 | (37.8033402849031, -122.414452158528) | ||
| 79034 | 79034 | 16939 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 79144 | 79144 | 16393 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.785180307755105 | -122.42217541209699 | (37.7851803077551, -122.422175412097) | |||
| 79278 | 79278 | 7198 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003395.6816300005 | 2111577.87165 | 37.778182264409295 | -122.431810290332 | (37.7781822644093, -122.431810290332) | |||
| 79524 | 79524 | 112827 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 79549 | 79549 | 18364 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.40728647423201 | (37.7619322307219, -122.407286474232) | |||
| 79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 79580 | 79580 | 19375 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011348.292859999 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | |||
| 79832 | 79832 | 665 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 79837 | 79837 | 21956 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015841.2226599995 | 2104083.6923599998 | 37.758302516993105 | -122.38823308755899 | (37.7583025169931, -122.388233087559) | |||
| 79863 | 79863 | 7185 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.43157522738599 | (37.7773563593355, -122.431575227386) | |||
| 80014 | 80014 | 13200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 80115 | 80115 | 7156 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | |||
| 80118 | 80118 | 15251 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007694.41094 | 2110207.30516 | 37.774661758829104 | -122.416842252889 | (37.7746617588291, -122.416842252889) | |||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 80323 | 80323 | 4626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010254.831619999 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | |||
| 80353 | 80353 | 18304 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.768310067349894 | -122.407895847634 | (37.7683100673499, -122.407895847634) | |||
| 80416 | 80416 | 17013 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 80486 | 80486 | 4599 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 80508 | 80508 | 17044 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Oak St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 80590 | 80590 | 15250 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007716.1596800005 | 2110227.0605599997 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | |||
| 80900 | 80900 | 6378 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006136.3622127995 | 2112667.0618884997 | 37.781327894236796 | -122.422406674363 | (37.7813278942368, -122.422406674363) | |||
| 80990 | 80990 | 17830 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.42804619277099 | (37.7885920838825, -122.428046192771) | |||
| 81060 | 81060 | 17309 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 70 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | |||
| 81143 | 81143 | 4596 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 81456 | 81456 | 17320 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 81530 | 81530 | 25702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 550 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.40167438060301 | (37.7752602760543, -122.401674380603) | |||
| 81633 | 81633 | 11103 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | |||
| 81839 | 81839 | 15324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 81870 | 81870 | 25701 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 550 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6012066.8540199995 | 2110350.0849099997 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | |||
| 81958 | 81958 | 18383 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | |||
| 82000 | 82000 | 23820 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 82140 | 82140 | 18940 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001564.88968 | 2115697.48907 | 37.7893897308811 | -122.438438883241 | (37.7893897308811, -122.438438883241) | |||
| 82261 | 82261 | 10710 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.783111376296795 | -122.430189039187 | (37.7831113762968, -122.430189039187) |
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");