Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
299 | 299 | 196427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.0 | 2109248.0 | 37.772163696411795 | -122.408394314545 | (37.7721636964118, -122.408394314545) | |||
23502 | 23502 | 214703 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992960.1777800005 | 2094882.5024400002 | 37.7317440249629 | -122.46669629760001 | (37.7317440249629, -122.4666962976) | |||
28327 | 28327 | 95833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) |
29079 | 29079 | 238214 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004038.9586 | 2100983.92112 | 37.7491302628649 | -122.428829515491 | (37.7491302628649, -122.428829515491) | |||
40213 | 40213 | 213483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994968.55628 | 2100619.47305 | 37.74761202648929 | -122.460168457927 | (37.7476120264893, -122.460168457927) | |||
40304 | 40304 | 196431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010634.804819999 | 2105805.21273 | 37.7627395712088 | -122.40636055221701 | (37.7627395712088, -122.406360552217) | |||
41298 | 41298 | 179046 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 179 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001233.0942400005 | 2093248.7296099998 | 37.727732024306796 | -122.437978219718 | (37.7277320243068, -122.437978219718) | |||
43631 | 43631 | 50013 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | ||
45242 | 45242 | 213576 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994554.1980800005 | 2099981.39248 | 37.7458361756945 | -122.46155502007299 | (37.7458361756945, -122.461555020073) | |||
48540 | 48540 | 238462 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002872.0423099995 | 2108810.23213 | 37.7705533146101 | -122.433423919803 | (37.7705533146101, -122.433423919803) | |||
49145 | 49145 | 237242 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 467 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998531.28643 | 2106457.3554 | 37.7638456860521 | -122.448269115134 | (37.7638456860521, -122.448269115134) | |||
49260 | 49260 | 213458 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5992978.54855 | 2099656.27544 | 37.7448526672074 | -122.46697971536301 | (37.7448526672074, -122.466979715363) | |||
49337 | 49337 | 213548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996162.65905 | 2093980.6549 | 37.729452065849294 | -122.455559574538 | (37.7294520658493, -122.455559574538) | |||
49350 | 49350 | 237136 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1346 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6010061.84572 | 2101335.33586 | 37.7504342222613 | -122.40802698336901 | (37.7504342222613, -122.408026983369) | |||
51380 | 51380 | 213399 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5991532.61986 | 2101100.8826900003 | 37.74873562236029 | -122.472084694454 | (37.7487356223603, -122.472084694454) | |||
53536 | 53536 | 238225 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004109.18497 | 2102785.07127 | 37.7540797743823 | -122.428715052456 | (37.7540797743823, -122.428715052456) | |||
54329 | 54329 | 213663 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994711.26401 | 2098940.32402 | 37.7429867016817 | -122.460936471749 | (37.7429867016817, -122.460936471749) | |||
54993 | 54993 | 213486 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 266 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994659.1262300005 | 2100320.90612 | 37.74677443390021 | -122.461216802127 | (37.7467744339002, -122.461216802127) | |||
60901 | 60901 | 214817 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5999206.70535 | 2094357.29664 | 37.7306604453021 | -122.445063116572 | (37.7306604453021, -122.445063116572) | |||
66290 | 66290 | 214629 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1552 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993710.5818300005 | 2104918.8610799997 | 37.7593446043956 | -122.464830603648 | (37.7593446043956, -122.464830603648) | |||
68028 | 68028 | 45482 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44263 | 5990295.806419999 | 2095116.94306 | 37.7322336167725 | -122.475924589162 | (37.7322336167725, -122.475924589162) | |
69824 | 69824 | 213337 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 280 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5992227.25788 | 2089749.39386 | 37.717607448608796 | -122.468856729068 | (37.7176074486088, -122.468856729068) | |||
71790 | 71790 | 178966 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 502 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010065.35663 | 2092212.96753 | 37.725386356787794 | -122.40737181018 | (37.7253863567878, -122.40737181018) | |||
74130 | 74130 | 214728 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 620 Faxon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994876.693580001 | 2092382.62427 | 37.724990382577 | -122.459889537684 | (37.724990382577, -122.459889537684) | |||
98111 | 98111 | 91929 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
119487 | 119487 | 179038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.733585526248795 | -122.480249118607 | (37.7335855262488, -122.480249118607) | |||
130695 | 130695 | 135954 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2993 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000463.47531 | 2115807.7741 | 37.789629833704 | -122.442257560964 | (37.789629833704, -122.442257560964) | |||
130781 | 130781 | 92609 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2528 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52920 | 5990746.65563 | 2112013.99975 | 37.778654601597 | -122.475599281341 | (37.778654601597, -122.475599281341) | |
132561 | 132561 | 45514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.7230900002 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | |
137004 | 137004 | 196478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 3ft | 6012656.37794 | 2096656.5486400002 | 37.7377321913814 | -122.39872653201799 | (37.7377321913814, -122.398726532018) | |||
140542 | 140542 | 121578 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 192X Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5999692.0 | 2106609.0 | 37.7643283535961 | -122.44426547040001 | (37.7643283535961, -122.4442654704) | |||
153524 | 153524 | 84212 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Tioga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50701 | 6010164.59248 | 2089152.68925 | 37.7169890199119 | -122.406813177404 | (37.7169890199119, -122.406813177404) | |
154069 | 154069 | 43063 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51464 | 5985346.9900400005 | 2112594.40853 | 37.779933731493294 | -122.49432133158399 | (37.7799337314933, -122.494321331584) | |
156360 | 156360 | 213359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 Beachmont Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5990836.58141 | 2095246.30718 | 37.7326201579899 | -122.474064462004 | (37.7326201579899, -122.474064462004) | |||
157195 | 157195 | 96899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987170.52326 | 2113675.9123 | 37.783009778520004 | -122.488092492463 | (37.78300977852, -122.488092492463) | |
160182 | 160182 | 214715 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993029.000080001 | 2094275.40431 | 37.7300810552916 | -122.466414259408 | (37.7300810552916, -122.466414259408) | |||
161006 | 161006 | 123799 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992759.08391 | 2112088.12025 | 37.7789745741229 | -122.468642970342 | (37.7789745741229, -122.468642970342) | |||
161354 | 161354 | 213697 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999258.3191599995 | 2093769.35408 | 37.7290490382604 | -122.44484243372601 | (37.7290490382604, -122.444842433726) | |||
161728 | 161728 | 179021 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5642 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5998317.810930001 | 2087173.37189 | 37.7108842770725 | -122.447619209286 | (37.7108842770725, -122.447619209286) | |||
164612 | 164612 | 214512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991834.49252 | 2106555.8498 | 37.7637309964006 | -122.47143825366501 | (37.7637309964006, -122.471438253665) | |||
165191 | 165191 | 213480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992360.2599 | 2095044.9531599998 | 37.7321554342216 | -122.46878213389401 | (37.7321554342216, -122.468782133894) | |||
166392 | 166392 | 237098 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005544.2957 | 2107858.77307 | 37.768092081506 | -122.4241128861 | (37.768092081506, -122.4241128861) | |||
166643 | 166643 | 213570 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995304.50078 | 2100206.2944900002 | 37.7464968590373 | -122.458976877776 | (37.7464968590373, -122.458976877776) | |||
166971 | 166971 | 238063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008227.615119999 | 2099350.5643599997 | 37.7448816154881 | -122.414229497799 | (37.7448816154881, -122.414229497799) | |||
167291 | 167291 | 238435 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000346.17489 | 2106832.48905 | 37.76497929947371 | -122.442018912365 | (37.7649792994737, -122.442018912365) | |||
169854 | 169854 | 214671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2472 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991737.91746 | 2098617.8202400003 | 37.741929649338495 | -122.47119390160299 | (37.7419296493385, -122.471193901603) | |||
171494 | 171494 | 179009 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002484.54609 | 2090211.4480599998 | 37.71946341819061 | -122.433434978747 | (37.7194634181906, -122.433434978747) | |||
171902 | 171902 | 213658 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Edgehill Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994707.10173 | 2098998.8404 | 37.7431471335475 | -122.460955103903 | (37.7431471335475, -122.460955103903) | |||
172041 | 172041 | 135929 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000857.17484 | 2120992.84894 | 37.8038891135616 | -122.44126758904 | (37.8038891135616, -122.44126758904) | |||
172980 | 172980 | 50792 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | |||
174646 | 174646 | 135972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2304 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002483.01544 | 2117812.37138 | 37.795248833821894 | -122.43541362484301 | (37.7952488338219, -122.435413624843) | |||
175242 | 175242 | 237430 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1120 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001920.37973 | 2100752.7732599997 | 37.748375447487 | -122.43613903599 | (37.748375447487, -122.43613903599) | |||
179988 | 179988 | 123298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 727 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994403.21402 | 2110559.5838200003 | 37.7748724608847 | -122.462844385609 | (37.7748724608847, -122.462844385609) | |||
181338 | 181338 | 213606 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 153 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994943.30534 | 2099473.46779 | 37.7444639307591 | -122.460172759368 | (37.7444639307591, -122.460172759368) | |||
182102 | 182102 | 103454 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988396.696330001 | 2114118.88325 | 37.7842975073391 | -122.48388298077101 | (37.7842975073391, -122.483882980771) | |||
188584 | 188584 | 214655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1797 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993099.09717 | 2103293.8568599997 | 37.754847490535795 | -122.466827267677 | (37.7548474905358, -122.466827267677) | |||
188604 | 188604 | 237088 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006692.25312 | 2107335.17282 | 37.7667191467912 | -122.420105051126 | (37.7667191467912, -122.420105051126) |
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");