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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
7256 | 7256 | 71253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | |
10582 | 10582 | 69800 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 3x3 | 5999779.7835 | 2091764.7216900003 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | |
10595 | 10595 | 78395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768554 | 5999771.76948 | 2091747.9413700001 | 37.723527995008396 | -122.442922299331 | (37.7235279950084, -122.442922299331) |
23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
26028 | 26028 | 78318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 3x6 | 6008900.368419999 | 2091273.5690900001 | 37.722741693447105 | -122.411332749116 | (37.7227416934471, -122.411332749116) | |
27276 | 27276 | 84392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012504.257680001 | 2099077.65785 | 37.744371568599796 | -122.39942241122499 | (37.7443715685998, -122.399422411225) | ||
34283 | 34283 | 71395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | ||
37977 | 37977 | 72335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 1 | 5988805.09626 | 2110041.06897 | 37.773124736634294 | -122.482171226619 | (37.7731247366343, -122.482171226619) | ||
39708 | 39708 | 70395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 16 | 6005551.028469999 | 2092833.80452 | 37.72683733826221 | -122.423021551618 | (37.7268373382622, -122.423021551618) | ||
41204 | 41204 | 78480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001855.9620900005 | 2090141.3500299999 | 37.719235261989 | -122.43560274687799 | (37.719235261989, -122.435602746878) | ||
45575 | 45575 | 78381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 631 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003379.385319999 | 2089522.9059 | 37.7176235608499 | -122.43029275202299 | (37.7176235608499, -122.430292752023) | ||
48211 | 48211 | 73744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 5 | 5995854.8721 | 2112478.1679599998 | 37.7802238906314 | -122.45796169978998 | (37.7802238906314, -122.45796169979) | ||
49933 | 49933 | 78363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6001858.247830001 | 2090145.2543799998 | 37.719246112288104 | -122.43559512512199 | (37.7192461122881, -122.435595125122) | ||
50364 | 50364 | 74315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000588.288430001 | 2093013.22945 | 37.727048705022895 | -122.440190437741 | (37.7270487050229, -122.440190437741) | ||
51040 | 51040 | 80385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6011729.10125 | 2092748.5600299998 | 37.7269499630479 | -122.40165799273599 | (37.7269499630479, -122.401657992736) | ||
54203 | 54203 | 78243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000646.02726 | 2093117.37413 | 37.727337949475896 | -122.439998300301 | (37.7273379494759, -122.439998300301) | ||
58345 | 58345 | 72333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 522 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 11 | 5989411.86479 | 2111751.27895 | 37.7778557732807 | -122.48019755247 | (37.7778557732807, -122.48019755247) | ||
61956 | 61956 | 72143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 12 | 6000249.61025 | 2091756.3807599999 | 37.723578399296606 | -122.44127109908301 | (37.7235783992966, -122.441271099083) | ||
62212 | 62212 | 78428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.42897407970699 | (37.7176015427445, -122.428974079707) | ||
67071 | 67071 | 78281 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000546.67018 | 2091525.62315 | 37.722961708992294 | -122.44022767776501 | (37.7229617089923, -122.440227677765) | ||
68144 | 68144 | 72942 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Gladstone Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 8 | 6006185.1456 | 2093706.6722400002 | 37.729269804734294 | -122.420891365245 | (37.7292698047343, -122.420891365245) | ||
69142 | 69142 | 70502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 78 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 11 | 6x7 | 6004601.41978 | 2093074.4867 | 37.727444566791 | -122.42632145556401 | (37.727444566791, -122.426321455564) | |
71360 | 71360 | 78237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | Permit Number 779512 | 5999758.88688 | 2090259.2057 | 37.7194395330998 | -122.442859978114 | (37.7194395330998, -122.442859978114) | |
71374 | 71374 | 73879 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 13 | 6004728.86924 | 2093550.8039799999 | 37.7287596319363 | -122.425914753389 | (37.7287596319363, -122.425914753389) | ||
72057 | 72057 | 70279 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Arago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1994 12:00:00 AM | 4 | 5999591.10411 | 2092976.06015 | 37.726889823596295 | -122.443635008456 | (37.7268898235963, -122.443635008456) | ||
73738 | 73738 | 72374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 766 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990089.45799 | 2110137.86742 | 37.7734651388758 | -122.477735579303 | (37.7734651388758, -122.477735579303) | ||
76359 | 76359 | 80388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1746 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6011768.66094 | 2092717.74347 | 37.7268675545821 | -122.401519069956 | (37.7268675545821, -122.401519069956) | ||
77024 | 77024 | 71498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Almaden Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 3 | 5995892.99596 | 2112465.9936599997 | 37.7801926535255 | -122.457828931472 | (37.7801926535255, -122.457828931472) | ||
77101 | 77101 | 70171 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990355.07569 | 2110118.2458599997 | 37.7734266747554 | -122.476815345127 | (37.7734266747554, -122.476815345127) | ||
94236 | 94236 | 83699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769773 | 6002629.0 | 2105596.0 | 37.76171402608121 | -122.434034805509 | (37.7617140260812, -122.434034805509) |
118380 | 118380 | 73360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6003402.60575 | 2092794.2901599999 | 37.72660737262 | -122.430445774353 | (37.72660737262, -122.430445774353) | ||
149645 | 149645 | 70521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 13 | 6004728.0596199995 | 2093562.7826599998 | 37.728792476979606 | -122.425918404632 | (37.7287924769796, -122.425918404632) | ||
150319 | 150319 | 78354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000366.91048 | 2090562.1790900002 | 37.7203060748337 | -122.44077999190701 | (37.7203060748337, -122.440779991907) | ||
150341 | 150341 | 72450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3880 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 1 | 5996319.64273 | 2114949.8711200003 | 37.7870372213321 | -122.456532645474 | (37.7870372213321, -122.456532645474) | ||
151473 | 151473 | 78234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 5 | 5999806.62934 | 2090324.19629 | 37.7196207041996 | -122.44269961461 | (37.7196207041996, -122.44269961461) | ||
152772 | 152772 | 73662 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 828 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/11/1995 12:00:00 AM | 6 | 6011416.18719 | 2109390.39573 | 37.7726273509159 | -122.403910314231 | (37.7726273509159, -122.403910314231) | ||
154108 | 154108 | 70417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6007053.10759 | 2093048.1738200001 | 37.7275105968359 | -122.417844078137 | (37.7275105968359, -122.417844078137) | ||
154117 | 154117 | 83424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 6012206.17554 | 2103813.0860099997 | 37.7573574093248 | -122.400785742066 | (37.7573574093248, -122.400785742066) | ||
154800 | 154800 | 79787 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003769.36441 | 2089501.7721900002 | 37.717587614063895 | -122.428943265313 | (37.7175876140639, -122.428943265313) | ||
155814 | 155814 | 78132 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 4 | 6009313.83221 | 2090783.0166900002 | 37.7214179201914 | -122.409868876754 | (37.7214179201914, -122.409868876754) | ||
158154 | 158154 | 79061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6012156.574130001 | 2103666.55961 | 37.756952313327396 | -122.40094698961599 | (37.7569523133274, -122.400946989616) | ||
160624 | 160624 | 72323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 3 | 5995855.97542 | 2112465.40969 | 37.7801889231991 | -122.45795695938101 | (37.7801889231991, -122.457956959381) | ||
162648 | 162648 | 82704 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6012930.127090001 | 2089200.7150299998 | 37.7172752435332 | -122.39725735994301 | (37.7172752435332, -122.397257359943) | ||
163564 | 163564 | 70459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 12 | 6004663.961569999 | 2093087.11793 | 37.727482784398 | -122.426106147103 | (37.727482784398, -122.426106147103) | ||
163917 | 163917 | 79764 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 26 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000559.455569999 | 2091550.49268 | 37.723030722971394 | -122.440185263946 | (37.7230307229714, -122.440185263946) | ||
164352 | 164352 | 78215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 14 | 6010959.76408 | 2090685.67745 | 37.7212427529373 | -122.404172468398 | (37.7212427529373, -122.404172468398) | ||
165384 | 165384 | 79359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 567 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2004 12:00:00 AM | 4 | 5985009.753819999 | 2112015.61326 | 37.778324785429895 | -122.495445265062 | (37.7783247854299, -122.495445265062) | ||
169316 | 169316 | 71443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 924 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012090.037819999 | 2119001.59006 | 37.7990550614973 | -122.40225525407101 | (37.7990550614973, -122.402255254071) | ||
172644 | 172644 | 70497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 182 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 13 | 6003784.020880001 | 2092788.04528 | 37.726611824260104 | -122.42912679089301 | (37.7266118242601, -122.429126790893) | ||
175813 | 175813 | 72259 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 231 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6002836.88949 | 2092205.7074400003 | 37.7249591941085 | -122.432359414777 | (37.7249591941085, -122.432359414777) | ||
177146 | 177146 | 70504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 437 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 18 | 6004727.68791 | 2092850.7822900002 | 37.7268374605684 | -122.42586902913901 | (37.7268374605684, -122.425869029139) | ||
178772 | 178772 | 78229 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 6 | 3x9 | 6008895.81383 | 2091285.82356 | 37.7227750861924 | -122.411349358704 | (37.7227750861924, -122.411349358704) | |
178828 | 178828 | 78251 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 16 | 6002953.557080001 | 2090366.3939 | 37.7199154633005 | -122.431824838869 | (37.7199154633005, -122.431824838869) | ||
179705 | 179705 | 70127 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6003416.21624 | 2092787.3454599997 | 37.726589075011894 | -122.430398228113 | (37.7265890750119, -122.430398228113) | ||
180951 | 180951 | 73633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 1 | 5983562.4874599995 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | ||
185087 | 185087 | 70501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6004654.404130001 | 2093072.1677599999 | 37.72744119435129 | -122.42613812337 | (37.7274411943513, -122.42613812337) | ||
188032 | 188032 | 72515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | 6 | 5995895.10246 | 2112445.80394 | 37.7801373389306 | -122.457820182784 | (37.7801373389306, -122.457820182784) |
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");