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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28848 | 28848 | 78416 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5990231.308540001 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | ||
28994 | 28994 | 38689 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1387 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | Permit Number 40602 | 6001181.9349 | 2110716.5649 | 37.775691594994505 | -122.439406673557 | (37.7756915949945, -122.439406673557) | |
29036 | 29036 | 68188 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2503 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1993 12:00:00 AM | 7 | Permit Number 31964 | 6004910.12814 | 2118236.0530000003 | 37.7965496977651 | -122.427045615765 | (37.7965496977651, -122.427045615765) | ||
29072 | 29072 | 97763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | ||
29236 | 29236 | 47400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 680 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45311 | 5994746.17876 | 2110902.86146 | 37.7758347580225 | -122.461682901678 | (37.7758347580225, -122.461682901678) | |
29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
29420 | 29420 | 31287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34935 | 5990781.283369999 | 2097640.71217 | 37.7391913809888 | -122.474430310711 | (37.7391913809888, -122.474430310711) | |
29579 | 29579 | 70603 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004588.06185 | 2091017.9173400002 | 37.7217969250666 | -122.42622128008999 | (37.7217969250666, -122.42622128009) | ||
29656 | 29656 | 45512 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3060 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988861.0879999995 | 2094953.9729400002 | 37.7317028513108 | -122.48087274987101 | (37.7317028513108, -122.480872749871) | |
29689 | 29689 | 31744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2435 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35234 | 5989813.6936 | 2098781.7399 | 37.742268240421204 | -122.47785915361601 | (37.7422682404212, -122.477859153616) | |
30016 | 30016 | 135826 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008677.52116 | 2119019.1422200003 | 37.798912179918396 | -122.414064992014 | (37.7989121799184, -122.414064992014) | ||||
30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
30312 | 30312 | 52936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 385 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48922 | 6001040.8792 | 2092508.1161099998 | 37.725687536143106 | -122.438589665189 | (37.7256875361431, -122.438589665189) | |
30408 | 30408 | 248049 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010499.7614 | 2099438.0486 | 37.7452491953942 | -122.40637896223 | (37.7452491953942, -122.40637896223) | ||||
30497 | 30497 | 48978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2801 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | 4 | Permit Number 46165 | 6004347.6822 | 2118813.41296 | 37.7981031596905 | -122.429032988006 | (37.7981031596905, -122.429032988006) | ||
30620 | 30620 | 121688 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6008462.12689 | 2120388.3747 | 37.802659650390794 | -122.414907290765 | (37.8026596503908, -122.414907290765) | ||||
30627 | 30627 | 38811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 326 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | 8 | Permit Number 40647 | 5992799.72049 | 2113267.67027 | 37.78221564478971 | -122.46858824048599 | (37.7822156447897, -122.468588240486) | |
30650 | 30650 | 43288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2210 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43057 | 6011175.09189 | 2105117.22439 | 37.760880718387796 | -122.404443451212 | (37.7608807183878, -122.404443451212) | |
30972 | 30972 | 45468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2211 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2001 12:00:00 AM | 3 | Permit Number 44247 | 6011982.05342 | 2101350.4265900003 | 37.750582981830895 | -122.40138778604401 | (37.7505829818309, -122.401387786044) | ||
31066 | 31066 | 196079 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015395.01764 | 2102273.41777 | 37.753307154219996 | -122.389649840082 | (37.75330715422, -122.389649840082) | ||||
31181 | 31181 | 73534 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2122 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | 5988232.3443 | 2100841.764 | 37.7478326165783 | -122.483477893757 | (37.7478326165783, -122.483477893757) | ||
31189 | 31189 | 43857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2784 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43478 | 5985281.0071 | 2096265.8928 | 37.7350962873764 | -122.493346251334 | (37.7350962873764, -122.493346251334) | |
31196 | 31196 | 32470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 6 | Permit Number 36978 | 6001062.3142800005 | 2106026.41955 | 37.762806815291796 | -122.439484183958 | (37.7628068152918, -122.439484183958) | |
31396 | 31396 | 62715 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 6 | Permit Number 23057 | 6007704.91578 | 2119106.60942 | 37.7990976677838 | -122.417436738332 | (37.7990976677838, -122.417436738332) | |
31401 | 31401 | 68521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.775270261614104 | -122.45949710563801 | (37.7752702616141, -122.459497105638) | |
31628 | 31628 | 68536 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 734 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32418 | 5993833.0352 | 2110476.78435 | 37.7746122584416 | -122.464810724109 | (37.7746122584416, -122.464810724109) | |
31730 | 31730 | 33993 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2034 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001441.2983 | 2115588.3906099997 | 37.789083143910496 | -122.438858673106 | (37.7890831439105, -122.438858673106) | ||
31779 | 31779 | 68325 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32140 | 6006815.0166 | 2113575.49994 | 37.783860503793996 | -122.42012334783199 | (37.783860503794, -122.420123347832) | |
31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) | |
31893 | 31893 | 79837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 6 | 6006109.456119999 | 2120466.37489 | 37.80274134031279 | -122.42305427704599 | (37.8027413403128, -122.423054277046) | ||
32114 | 32114 | 49856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 76@ LAGUNA Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 4 | Permit Number 46629 | 6003390.669840001 | 2119840.41127 | 37.80086881239821 | -122.432417918359 | (37.8008688123982, -122.432417918359) | ||
32142 | 32142 | 78209 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 602 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6011148.7159 | 2091968.9624700001 | 37.7247769455958 | -122.403609556646 | (37.7247769455958, -122.403609556646) | ||
32253 | 32253 | 38647 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1920 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 7 | Permit Number 41183 | 6000481.01223 | 2115413.16411 | 37.7885473368318 | -122.442168546961 | (37.7885473368318, -122.442168546961) | |
32276 | 32276 | 31868 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.804001595372604 | -122.445454333359 | (37.8040015953726, -122.445454333359) | |
32300 | 32300 | 196138 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6013054.7193 | 2103811.53724 | 37.757400449098604 | -122.39785101412 | (37.7574004490986, -122.39785101412) | ||||
32322 | 32322 | 80604 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.956 | 2105074.08431 | 37.761000400173295 | -122.38964506649201 | (37.7610004001733, -122.389645066492) | ||
32465 | 32465 | 248037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010488.35763 | 2099431.59018 | 37.745230824035204 | -122.40641793974599 | (37.7452308240352, -122.406417939746) | ||||
32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
32768 | 32768 | 248178 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 218 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6007415.21428 | 2098671.9184 | 37.7429725382626 | -122.416990561277 | (37.7429725382626, -122.416990561277) | ||||
32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
32935 | 32935 | 196267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013259.78096 | 2090144.7382099999 | 37.719885690359604 | -122.396184017281 | (37.7198856903596, -122.396184017281) | ||||
32985 | 32985 | 47409 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1245 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45320 | 5994762.6518 | 2112104.25477 | 37.7791344121855 | -122.461713045527 | (37.7791344121855, -122.461713045527) | |
33004 | 33004 | 37858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 566St. Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 7 | Permit Number 40145 | 6001842.58186 | 2090205.4937 | 37.719410626184796 | -122.43565358376699 | (37.7194106261848, -122.435653583767) | |
33070 | 33070 | 249679 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999741.43988 | 2117216.47572 | 37.793456580320395 | -122.44485702433998 | (37.7934565803204, -122.44485702434) | ||||
33081 | 33081 | 31729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.4261 | 2098592.0294 | 37.7417654319331 | -122.47676743237601 | (37.7417654319331, -122.476767432376) | |
33147 | 33147 | 78042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1975 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2000 12:00:00 AM | 2 | 5986293.4379 | 2101820.6717 | 37.7504073916771 | -122.490254444499 | (37.7504073916771, -122.490254444499) | ||
33166 | 33166 | 43255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43041 | 6010125.284580001 | 2093194.02185 | 37.7280834802679 | -122.40723376965 | (37.7280834802679, -122.40723376965) | |
33246 | 33246 | 102378 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | ||||
33519 | 33519 | 64497 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1542 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25376 | 6000402.8495 | 2110654.2627 | 37.7754761607449 | -122.442097242557 | (37.7754761607449, -122.442097242557) | |
33574 | 33574 | 53443 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 5 | Permit Number 23058 | 6007695.329609999 | 2119167.05545 | 37.7992630980807 | -122.41747419599899 | (37.7992630980807, -122.417474195999) | |
33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
33694 | 33694 | 45545 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 150 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44298 | 5987075.11092 | 2094929.45879 | 37.7315315673308 | -122.48704535198 | (37.7315315673308, -122.48704535198) | |
33737 | 33737 | 78509 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.48067316246402 | (37.7312164799499, -122.480673162464) | ||
33765 | 33765 | 32484 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 203 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1996 12:00:00 AM | 7 | Permit Number 36992 | 6001040.84571 | 2106331.01428 | 37.7636419356406 | -122.43958027293002 | (37.7636419356406, -122.43958027293) | ||
33861 | 33861 | 43701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3342 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43344 | 5992980.72479 | 2110052.83989 | 37.77339904403011 | -122.46772817008001 | (37.7733990440301, -122.46772817008) | |
33876 | 33876 | 67957 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 886 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31677 | 5987616.4327300005 | 2109922.8540000003 | 37.772730941918894 | -122.48627423406799 | (37.7727309419189, -122.486274234068) | |
34185 | 34185 | 64492 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1570 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25369 | 6000283.6045 | 2110639.8088 | 37.775429677687995 | -122.442508700238 | (37.775429677688, -122.442508700238) | |
34202 | 34202 | 246791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010143.06435 | 2098755.47908 | 37.743355047810205 | -122.40756425069901 | (37.7433550478102, -122.407564250699) | ||||
34244 | 34244 | 196191 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 Armstrong Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013892.03543 | 2092881.8479400002 | 37.727436404540796 | -122.39419004313 | (37.7274364045408, -122.39419004313) | ||||
34255 | 34255 | 68402 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 127 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | Permit Number 32234 | 6002270.3264 | 2093907.92717 | 37.7296009620913 | -122.434439606907 | (37.7296009620913, -122.434439606907) | |
34260 | 34260 | 67963 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 882 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | Permit Number 31684 | 5986994.57488 | 2109967.9859599997 | 37.7728185972219 | -122.48842859801701 | (37.7728185972219, -122.488428598017) | |
34278 | 34278 | 31819 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 195 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009854.1227 | 2111441.50203 | 37.778171816101704 | -122.409458466633 | (37.7781718161017, -122.409458466633) | |
34347 | 34347 | 44742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) | |
34633 | 34633 | 56154 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 442 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 6 | Permit Number 12262 | 5990943.20975 | 2112366.81543 | 37.7796347288322 | -122.474945092225 | (37.7796347288322, -122.474945092225) | ||
34700 | 34700 | 73853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000885.5664 | 2088247.4069700001 | 37.713979754329 | -122.438821382721 | (37.713979754329, -122.438821382721) | ||
34763 | 34763 | 196288 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012383.755890001 | 2104753.48944 | 37.7599494533344 | -122.40023764215799 | (37.7599494533344, -122.400237642158) | ||||
34883 | 34883 | 34644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1507 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38323 | 5987736.3957 | 2105018.4617 | 37.7592718242591 | -122.485499299017 | (37.7592718242591, -122.485499299017) | |
34995 | 34995 | 47407 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 615 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45318 | 5993448.607469999 | 2111270.20769 | 37.7767686143956 | -122.46619819632 | (37.7767686143956, -122.46619819632) | |
35084 | 35084 | 63426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3511 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1987 12:00:00 AM | 11 | Permit Number 24010 | 5997342.80811 | 2116025.28768 | 37.790048717230796 | -122.45307040038999 | (37.7900487172308, -122.45307040039) | ||
35147 | 35147 | 196292 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012388.17486 | 2104794.0427599996 | 37.760061050199596 | -122.400225207229 | (37.7600610501996, -122.400225207229) | ||||
35350 | 35350 | 60550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.6948599997 | 37.7788080303748 | -122.49530921969601 | (37.7788080303748, -122.495309219696) | |
35355 | 35355 | 70484 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 947 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6005167.83048 | 2092104.0549400002 | 37.724811975074104 | -122.424294379186 | (37.7248119750741, -122.424294379186) | ||
35433 | 35433 | 73063 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 774 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1999 12:00:00 AM | 4 | 5992292.3763 | 2110183.95951 | 37.7737192935019 | -122.47011879273799 | (37.7737192935019, -122.470118792738) | ||
35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
35493 | 35493 | 48678 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 581 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | 2 | Permit Number 45960 | 6005081.6405 | 2110909.2726 | 37.776441882073605 | -122.42593033475201 | (37.7764418820736, -122.425930334752) | ||
35627 | 35627 | 214221 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 144 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000463.1265199995 | 2095257.0070900002 | 37.7332024726215 | -122.44078400199699 | (37.7332024726215, -122.440784001997) | ||||
35867 | 35867 | 31577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1723 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35116 | 5989021.1478 | 2103586.321 | 37.7554143192924 | -122.48095119881799 | (37.7554143192924, -122.480951198818) | |
36212 | 36212 | 60790 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 264 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1983 12:00:00 AM | 6 | Permit Number 20464 | 5998458.1657 | 2112249.2928 | 37.7797446843644 | -122.44893925935301 | (37.7797446843644, -122.448939259353) | ||
36225 | 36225 | 32121 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 278#1 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35483 | 6003519.82131 | 2106657.45741 | 37.7646790482105 | -122.431029575562 | (37.7646790482105, -122.431029575562) | |
36455 | 36455 | 78402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 593 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5985636.206590001 | 2111885.61878 | 37.7780045190041 | -122.493268584238 | (37.7780045190041, -122.493268584238) | ||
36533 | 36533 | 45511 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3060 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988860.89889 | 2094966.83884 | 37.731738166776 | -122.480874345273 | (37.731738166776, -122.480874345273) | |
36553 | 36553 | 60584 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1531 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 8 | Permit Number 20201 | 6000391.1057 | 2110950.8694 | 37.7762898982244 | -122.442159163176 | (37.7762898982244, -122.442159163176) | |
36603 | 36603 | 45048 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1874 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2001 12:00:00 AM | 0 | Permit Number 43934 | 5988178.9536632 | 2102555.33901725 | 37.752534528362204 | -122.48378813711001 | (37.7525345283622, -122.48378813711) | |
36830 | 36830 | 32000 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.9843099997 | 37.7203526336359 | -122.42585972476299 | (37.7203526336359, -122.425859724763) | |
37053 | 37053 | 218147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Ashton Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | ||||
37165 | 37165 | 67394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 751 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 5 | Permit Number 30891 | 5990660.6415099995 | 2110260.19062 | 37.773834136535704 | -122.475768727884 | (37.7738341365357, -122.475768727884) | |
37332 | 37332 | 31458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 2 | Permit Number 35026 | 6001236.64987 | 2102602.74693 | 37.7534161628409 | -122.438635890359 | (37.7534161628409, -122.438635890359) | |
37394 | 37394 | 39047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009496.342 | 2105638.057 | 37.762216848178504 | -122.410286304804 | (37.7622168481785, -122.410286304804) | ||
37503 | 37503 | 43691 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 525 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43335 | 5993425.14726 | 2111878.89622 | 37.7784385555739 | -122.466323599337 | (37.7784385555739, -122.466323599337) | |
37525 | 37525 | 55624 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 428 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 9 | Permit Number 30322 | 6005737.866 | 2111395.9106 | 37.7778151358824 | -122.42369487071699 | (37.7778151358824, -122.423694870717) | ||
37562 | 37562 | 43855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2762 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43476 | 5985275.17 | 2096431.4539 | 37.7355505326544 | -122.493378625972 | (37.7355505326544, -122.493378625972) | |
37616 | 37616 | 34801 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 311 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38437 | 5998132.09009 | 2088842.02869 | 37.715455411421 | -122.44838118866699 | (37.715455411421, -122.448381188667) | |
38014 | 38014 | 43592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1943 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43253 | 5986599.433999999 | 2102022.9577 | 37.750980680205004 | -122.48921117318399 | (37.750980680205, -122.489211173184) | |
38064 | 38064 | 34679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2069 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 4 | Permit Number 41918 | 6003062.63239 | 2118890.11528 | 37.7982409403347 | -122.43348511594 | (37.7982409403347, -122.43348511594) | |
38516 | 38516 | 67659 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 9 | Permit Number 31260 | 6014110.85725 | 2093863.20548 | 37.7301431741556 | -122.393502220965 | (37.7301431741556, -122.393502220965) | |
38535 | 38535 | 62099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2423 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 8 | Permit Number 22192 | 6003671.00405 | 2116729.08453 | 37.7923418022811 | -122.431225634948 | (37.7923418022811, -122.431225634948) | ||
38558 | 38558 | 57413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.78374972289961 | -122.455606076565 | (37.7837497228996, -122.455606076565) | ||
38589 | 38589 | 60786 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 184 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 2 | Permit Number 20458 | 5998502.4989 | 2112521.0456 | 37.780493382223 | -122.448805471636 | (37.780493382223, -122.448805471636) |
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");