Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2750 | 2750 | 23535 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005732.6393 | 2119914.78395 | 37.8012055419589 | -122.424319001733 | (37.8012055419589, -122.424319001733) | |||
14549 | 14549 | 117222 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013683.04729 | 2111373.4456700003 | 37.7781987427098 | -122.396207957236 | (37.7781987427098, -122.396207957236) | |
16745 | 16745 | 21990 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015917.77015 | 2103307.70313 | 37.7561760563058 | -122.387914203395 | (37.7561760563058, -122.387914203395) | |||
22886 | 22886 | 128596 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 298 Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013044.18736 | 2117620.02573 | 37.795314828765704 | -122.398856538904 | (37.7953148287657, -122.398856538904) | |||
24655 | 24655 | 190213 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Main St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013892.82186 | 2116649.49416 | 37.7926972260507 | -122.39585206404 | (37.7926972260507, -122.39585206404) | |||
26438 | 26438 | 128031 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2601 Jones St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007875.631019999 | 2121383.5441900003 | 37.8053591615717 | -122.417007420861 | (37.8053591615717, -122.417007420861) | |||
26869 | 26869 | 127646 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 30 Grove St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007900.6596099995 | 2111695.89865 | 37.7787606804851 | -122.416234247632 | (37.7787606804851, -122.416234247632) | |||
28022 | 28022 | 189675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 10 | : Yard 23 | Tree 1 | Private 1 | 8 | 6017194.50129 | 2102669.93128 | 37.754495514781496 | -122.383454393407 | (37.7544955147815, -122.383454393407) | ||||
33094 | 33094 | 189778 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 800 Wisconsin St | 10 | : 4 | Tree 1 | Private 1 | 32 | Width 5ft | 6012724.71744 | 2103552.97155 | 37.7566721007586 | -122.39897415133001 | (37.7566721007586, -122.39897415133) | |||
34067 | 34067 | 192079 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Vermont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011143.862840001 | 2107814.02339 | 37.7682837747162 | -122.40474132015301 | (37.7682837747162, -122.404741320153) | |||
34453 | 34453 | 190309 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014221.95 | 2115175.4144200003 | 37.7886680501377 | -122.394609987883 | (37.7886680501377, -122.394609987883) | |||
41194 | 41194 | 128698 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012762.04961 | 2117890.12021 | 37.796040719264795 | -122.399851762841 | (37.7960407192648, -122.399851762841) | |||
41698 | 41698 | 224417 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Treat Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6008526.85827 | 2106028.33873 | 37.763234079605496 | -122.41366699885 | (37.7632340796055, -122.41366699885) | |||
42219 | 42219 | 190104 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014895.60705 | 2113505.18566 | 37.7841194132319 | -122.39216235970899 | (37.7841194132319, -122.392162359709) | |||
42891 | 42891 | 189707 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Wisconsin St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6012643.92045 | 2105052.7047 | 37.760785535943796 | -122.399358858836 | (37.7607855359438, -122.399358858836) | |||
43095 | 43095 | 190249 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012276.22435 | 2114985.84699 | 37.788039177600496 | -122.401328625912 | (37.7880391776005, -122.401328625912) | |||
43997 | 43997 | 190107 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Utah St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010614.77388 | 2107190.58962 | 37.766542381460496 | -122.40652746008999 | (37.7665423814605, -122.40652746009) | |||
45734 | 45734 | 127516 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 335 Powell St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010248.078369999 | 2114825.1066799997 | 37.7874844595824 | -122.408334342849 | (37.7874844595824, -122.408334342849) | |||
46834 | 46834 | 189823 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 9ft | 6010524.410519999 | 2107382.85181 | 37.767065233807 | -122.40685356416 | (37.767065233807, -122.40685356416) | |||
48167 | 48167 | 189619 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Harrison St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 0ft | 6010873.70675 | 2110523.15136 | 37.775707313965796 | -122.40586662925399 | (37.7757073139658, -122.405866629254) | |||
49276 | 49276 | 189053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1498 Fairfax Ave | 10 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6016104.71748 | 2097862.0759900003 | 37.74123385017221 | -122.38688790245199 | (37.7412338501722, -122.386887902452) | |||
49326 | 49326 | 128605 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012699.96192 | 2117568.44615 | 37.7951540173845 | -122.400043998347 | (37.7951540173845, -122.400043998347) | |||
56706 | 56706 | 128019 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007990.455580001 | 2121370.14794 | 37.80532883730721 | -122.41660910483 | (37.8053288373072, -122.41660910483) | |||
56708 | 56708 | 192090 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 09th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6010627.85594 | 2108396.4287 | 37.7698540719244 | -122.406567193038 | (37.7698540719244, -122.406567193038) | |||
61170 | 61170 | 127928 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Leavenworth St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007304.867269999 | 2122022.34985 | 37.807081035924604 | -122.41902796546199 | (37.8070810359246, -122.419027965462) | |||
61388 | 61388 | 128136 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Jones St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007849.22667 | 2121901.0419900003 | 37.8067785939243 | -122.417135488839 | (37.8067785939243, -122.417135488839) | |||
63708 | 63708 | 128295 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6011737.98777 | 2120794.57425 | 37.8039585025572 | -122.403599691991 | (37.8039585025572, -122.403599691991) | |||
65859 | 65859 | 128517 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 80 Davis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6013378.41738 | 2117243.32943 | 37.794299127249495 | -122.39767360667 | (37.7942991272495, -122.39767360667) | |||
67575 | 67575 | 189633 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 11th St | 10 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007281.55408 | 2110475.16176 | 37.775373998252 | -122.418289406239 | (37.775373998252, -122.418289406239) | |||
71282 | 71282 | 128340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6011898.73236 | 2120508.7915 | 37.8031827905156 | -122.403023308405 | (37.8031827905156, -122.403023308405) | |||
71448 | 71448 | 128279 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6011105.78166 | 2121393.68686 | 37.8055681837754 | -122.405829721081 | (37.8055681837754, -122.405829721081) | |||
73345 | 73345 | 126807 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2500 Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999789.75355 | 2119522.41548 | 37.799790835544 | -122.444855690653 | (37.799790835544, -122.444855690653) | |||
73586 | 73586 | 128102 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2021 Grant Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010206.19487 | 2122052.6055400004 | 37.807327060752705 | -122.408989401833 | (37.8073270607527, -122.408989401833) | |||
75106 | 75106 | 128227 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 68 Green St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012447.31035 | 2119548.61119 | 37.800576985991995 | -122.401057420084 | (37.800576985992, -122.401057420084) | |||
119595 | 119595 | 128190 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009553.486409999 | 2122223.45626 | 37.8077595896989 | -122.41126033031 | (37.8077595896989, -122.41126033031) | |||
123745 | 123745 | 128119 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2300 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009753.33823 | 2122179.92363 | 37.8076512663509 | -122.410565615735 | (37.8076512663509, -122.410565615735) | |||
126472 | 126472 | 102344 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401X Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |||
126719 | 126719 | 102329 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201X 18th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | |||
129922 | 129922 | 128152 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007589.3287 | 2121660.05846 | 37.8061022902586 | -122.418017824459 | (37.8061022902586, -122.418017824459) | |||
130097 | 130097 | 192114 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 367 Tehama St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011511.08906 | 2112618.797 | 37.7814970962558 | -122.403809248424 | (37.7814970962558, -122.403809248424) | |||
132178 | 132178 | 116054 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011511.93551 | 2105220.59815 | 37.761183378041395 | -122.403285723377 | (37.7611833780414, -122.403285723377) | ||
133228 | 133228 | 128687 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 270 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012976.83244 | 2117918.4775900003 | 37.7961305534334 | -122.3991105587 | (37.7961305534334, -122.3991105587) | |||
133635 | 133635 | 190182 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014104.30918 | 2116851.60176 | 37.7932639293376 | -122.395134467085 | (37.7932639293376, -122.395134467085) | |||
134732 | 134732 | 112705 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010037.29215 | 2121993.9150799997 | 37.8071564485694 | -122.40956978471701 | (37.8071564485694, -122.409569784717) | |||
136474 | 136474 | 128656 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013029.0227 | 2118872.45132 | 37.79875284613029 | -122.39899695996401 | (37.7987528461303, -122.398996959964) | |||
151007 | 151007 | 126685 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6000577.63851 | 2117912.00016 | 37.7954139934018 | -122.442013668413 | (37.7954139934018, -122.442013668413) | |||
152968 | 152968 | 127602 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7 Ada Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008099.06699 | 2114176.10404 | 37.785581881738295 | -122.415723537934 | (37.7855818817383, -122.415723537934) | |||
153091 | 153091 | 128176 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009058.8644 | 2122154.44362 | 37.8075423458653 | -122.41296721299 | (37.8075423458653, -122.41296721299) | |||
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) | |||
156394 | 156394 | 128330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Union St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012241.16864 | 2119813.0349 | 37.801291527950895 | -122.401789355812 | (37.8012915279509, -122.401789355812) | |||
156831 | 156831 | 225363 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 127 Otis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007101.59179 | 2109547.6272400003 | 37.7728170781872 | -122.41884614233801 | (37.7728170781872, -122.418846142338) | |||
159829 | 159829 | 128674 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013352.81872 | 2117972.32063 | 37.7962993390922 | -122.39781334060899 | (37.7962993390922, -122.397813340609) | |||
163287 | 163287 | 190162 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014419.09682 | 2117039.99182 | 37.7937987048989 | -122.394058466947 | (37.7937987048989, -122.394058466947) | |||
165702 | 165702 | 128261 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 Union St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011203.18453 | 2119720.84777 | 37.800980424562 | -122.40537476125401 | (37.800980424562, -122.405374761254) | |||
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) | |||
166608 | 166608 | 117413 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010079.003190001 | 2122292.43405 | 37.8079784442232 | -122.409446515568 | (37.8079784442232, -122.409446515568) | |||
167245 | 167245 | 192128 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 807 Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011244.54236 | 2113515.64035 | 37.7839447235201 | -122.40479453575001 | (37.7839447235201, -122.40479453575) | |||
172581 | 172581 | 126840 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1700 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001920.52561 | 2121141.93832 | 37.8043589886428 | -122.437598488187 | (37.8043589886428, -122.437598488187) | |||
172800 | 172800 | 128758 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010964.76116 | 2114852.0466 | 37.7875985367791 | -122.405856651262 | (37.7875985367791, -122.405856651262) | |||
174125 | 174125 | 127070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 10 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6001375.8548 | 2119619.21037 | 37.8001469985396 | -122.43937414650499 | (37.8001469985396, -122.439374146505) | |||
178362 | 178362 | 190239 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013014.792090001 | 2115287.50662 | 37.7889086430678 | -122.398794473992 | (37.7889086430678, -122.398794473992) | |||
180889 | 180889 | 128535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012175.3004 | 2116815.4843099997 | 37.7930572975043 | -122.401806466309 | (37.7930572975043, -122.401806466309) | |||
181161 | 181161 | 128579 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012837.111409999 | 2117845.43557 | 37.7959222102009 | -122.399588893731 | (37.7959222102009, -122.399588893731) | |||
181326 | 181326 | 225510 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6004199.54992 | 2106135.78909 | 37.7632851647079 | -122.42864138448999 | (37.7632851647079, -122.42864138449) | |||
183858 | 183858 | 225374 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 33 Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6006557.54483 | 2109229.9019 | 37.771914032028 | -122.420705506847 | (37.771914032028, -122.420705506847) |
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");