Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 3207 | 3207 | 253355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3225 | 3225 | 253351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3233 | 3233 | 253345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 5466 | 5466 | 21688 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1881 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 2 | 4x4 | 6003696.9634 | 2114537.7544 | 37.7863264365495 | -122.430979349218 | (37.7863264365495, -122.430979349218) | ||
| 6750 | 6750 | 21685 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 4x4 | 6003694.6838 | 2114582.3856 | 37.7864488534059 | -122.43099042257299 | (37.7864488534059, -122.430990422573) | ||
| 8560 | 8560 | 98097 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.789170503156704 | -122.420050723983 | (37.7891705031567, -122.420050723983) | |||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 19239 | 19239 | 40472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
| 32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
| 33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 37082 | 37082 | 182550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986517.6568 | 2105641.9803 | 37.760912753017394 | -122.48976008582899 | (37.7609127530174, -122.489760085829) | |||
| 38483 | 38483 | 237995 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4120 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002335.689069999 | 2101815.5144 | 37.751317069626204 | -122.434778894126 | (37.7513170696262, -122.434778894126) | |||
| 38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
| 39866 | 39866 | 182572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.48023167480301 | (37.7410584915124, -122.480231674803) | |||
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 41047 | 41047 | 139143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004425.4721 | 2114070.1832 | 37.7850838549959 | -122.428425556733 | (37.7850838549959, -122.428425556733) | |||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 44471 | 44471 | 182556 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986624.9706 | 2105696.7397 | 37.7610693723866 | -122.48939296609501 | (37.7610693723866, -122.489392966095) | |||
| 44756 | 44756 | 97495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988364.44571 | 2111930.92454 | 37.778288112362 | -122.483834071993 | (37.778288112362, -122.483834071993) | |
| 45819 | 45819 | 244240 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.0678 | 2110158.7025 | 37.774407460347796 | -122.424256515939 | (37.7744074603478, -122.424256515939) | |||
| 46200 | 46200 | 214462 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 139 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000481.8425900005 | 2095189.9969400002 | 37.7330195442146 | -122.440714490676 | (37.7330195442146, -122.440714490676) | |||
| 46653 | 46653 | 244106 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1950 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997207.2964 | 2108819.9511 | 37.7702569879828 | -122.453018925124 | (37.7702569879828, -122.453018925124) | |||
| 46789 | 46789 | 244991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | |||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 52716 | 52716 | 92396 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.3792 | 2099657.153 | 37.7444373876676 | -122.491845148303 | (37.7444373876676, -122.491845148303) |
| 52829 | 52829 | 135900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006826.338330001 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | |||
| 54862 | 54862 | 183412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985653.7417 | 2097035.0769 | 37.7372300576086 | -122.492114208587 | (37.7372300576086, -122.492114208587) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
| 61894 | 61894 | 178932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000025.30894 | 2091607.27425 | 37.7231562071699 | -122.44203576925501 | (37.7231562071699, -122.442035769255) | |||
| 63020 | 63020 | 178940 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004061.97855 | 2093834.65882 | 37.729501322606 | -122.428240459522 | (37.729501322606, -122.428240459522) | |||
| 64163 | 64163 | 196408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.776804005729204 | -122.41021603036002 | (37.7768040057292, -122.41021603036) | |||
| 65110 | 65110 | 49209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001476.6938 | 2115031.787 | 37.7875568675655 | -122.438696309687 | (37.7875568675655, -122.438696309687) | ||
| 66227 | 66227 | 196412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | |||
| 70069 | 70069 | 118023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.49772445801202 | (37.780241619998, -122.497724458012) | |||
| 76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 77132 | 77132 | 244320 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005500.9462 | 2110499.2518 | 37.775339752374 | -122.424450664906 | (37.775339752374, -122.424450664906) | |||
| 77549 | 77549 | 36014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 77745 | 77745 | 109408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 BELGRAVE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 5997621.5 | 2104846.8 | 37.759371453278206 | -122.45129961243099 | (37.7593714532782, -122.451299612431) | ||
| 80303 | 80303 | 42522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42635 | 6000743.4333065 | 2100900.95079718 | 37.748715370273 | -122.44021950385 | (37.748715370273, -122.44021950385) | |||
| 80994 | 80994 | 88228 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
| 82029 | 82029 | 93176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 82968 | 82968 | 43831 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388718998 | 37.737232941963605 | -122.492392332362 | (37.7372329419636, -122.492392332362) | ||
| 83883 | 83883 | 50539 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 199 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096.0 | 2099195.0 | 37.744334505185705 | -122.421589192303 | (37.7443345051857, -122.421589192303) | |||
| 83985 | 83985 | 115105 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 84406 | 84406 | 122604 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.3193700002 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | ||
| 85911 | 85911 | 47714 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 86060 | 86060 | 102208 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 86937 | 86937 | 36430 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
| 88018 | 88018 | 46638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 89242 | 89242 | 50787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
| 90463 | 90463 | 37879 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 92723 | 92723 | 107754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
| 93317 | 93317 | 93179 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 93484 | 93484 | 42563 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42649 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 93746 | 93746 | 31921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 96310 | 96310 | 34129 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1401 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
| 96807 | 96807 | 48495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688(REVISED) Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45836 | 6008651.5358149 | 2098064.55146278 | 37.7413743105027 | -122.412672757895 | (37.7413743105027, -122.412672757895) | |||
| 97850 | 97850 | 97824 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6002402.0 | 2104748.0 | 37.7593727378271 | -122.434759263601 | (37.7593727378271, -122.434759263601) | |||
| 98609 | 98609 | 42762 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 100849 | 100849 | 41304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | |||
| 102813 | 102813 | 35300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
| 104740 | 104740 | 42036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.42675775960501 | (37.7436701266667, -122.426757759605) | |||
| 105211 | 105211 | 84787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.76050301831479 | -122.444429006349 | (37.7605030183148, -122.444429006349) | |||
| 105582 | 105582 | 44167 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
| 106645 | 106645 | 34098 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
| 107585 | 107585 | 45063 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.748207264307496 | -122.484739557427 | (37.7482072643075, -122.484739557427) | |||
| 107704 | 107704 | 37692 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 562 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40078 | 6007845.87669797 | 2104655.5935128 | 37.759426574444106 | -122.415925080154 | (37.7594265744441, -122.415925080154) | ||
| 110660 | 110660 | 99280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001309.9 | 2109637.7 | 37.7727365843062 | -122.43888668006001 | (37.7727365843062, -122.43888668006) | |||||
| 111078 | 111078 | 32925 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 338 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | |
| 112419 | 112419 | 110545 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 112820 | 112820 | 121653 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993098.0 | 2103247.0 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | ||||
| 114011 | 114011 | 32382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 115038 | 115038 | 116014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 469 PACHECO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5993702.0 | 2101802.0 | 37.7507860118971 | -122.464633955158 | (37.7507860118971, -122.464633955158) | ||||
| 115422 | 115422 | 36368 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 143 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39319 | 5995629.61458477 | 2093656.01088528 | 37.7285300690508 | -122.457378871767 | (37.7285300690508, -122.457378871767) | ||
| 115696 | 115696 | 40388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 115915 | 115915 | 40512 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 445 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41576 | 5992747.41981015 | 2094935.12337926 | 37.7318762282888 | -122.46743566386299 | (37.7318762282888, -122.467435663863) | ||
| 116072 | 116072 | 43862 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 117113 | 117113 | 103651 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |
| 118168 | 118168 | 135902 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | ||||
| 119096 | 119096 | 36426 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39338 | 5996108.64471019 | 2094137.0690645 | 37.729878441846104 | -122.455757608246 | (37.7298784418461, -122.455757608246) | |||
| 119894 | 119894 | 36423 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 120418 | 120418 | 36384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
| 120573 | 120573 | 40228 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | |||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 121128 | 121128 | 39754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 121592 | 121592 | 37267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 122559 | 122559 | 49139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) |
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");