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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 162332 | 162332 | 85242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981385.546 | 2104841.9152 | 37.7584150182243 | -122.507450124372 | (37.7584150182243, -122.507450124372) | ||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 43146 | 43146 | 118427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | |||
| 157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 51315 | 51315 | 34818 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 51735 | 51735 | 88092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51095 | 5984042.9711 | 2104115.7287 | 37.756577293333294 | -122.49820607925 | (37.7565772933333, -122.49820607925) | |
| 158401 | 158401 | 118027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.780415056002205 | -122.49786249135201 | (37.7804150560022, -122.497862491352) | |||
| 174540 | 174540 | 184306 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984381.1972 | 2104548.1361 | 37.757784389614 | -122.497068306014 | (37.757784389614, -122.497068306014) | |||
| 95593 | 95593 | 96005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3448 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2011 12:00:00 AM | 3x3 | Permit Number 767659 | 5984913.0 | 2111119.0 | 37.775857277323105 | -122.495713813843 | (37.7758572773231, -122.495713813843) | ||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | 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) | ||
| 186494 | 186494 | 182276 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985061.2024 | 2105018.6781 | 37.759116193094 | -122.494751291704 | (37.759116193094, -122.494751291704) | |||
| 43063 | 43063 | 185135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5985252.6176 | 2097020.7349 | 37.7371672218976 | -122.493500001953 | (37.7371672218976, -122.493500001953) | |||
| 71523 | 71523 | 92404 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985265.6119 | 2104693.7127 | 37.7582358909523 | -122.494020406574 | (37.7582358909523, -122.494020406574) |
| 33113 | 33113 | 183374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2725 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985535.6187 | 2096728.138 | 37.736380379394 | -122.492500010635 | (37.736380379394, -122.492500010635) | |||
| 159299 | 159299 | 43835 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43458 | 5985569.0545 | 2097059.5514 | 37.737292307195396 | -122.492408808668 | (37.7372923071954, -122.492408808668) | |
| 54310 | 54310 | 182541 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1587 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985582.1491 | 2104435.4669 | 37.7575453355233 | -122.492906676836 | (37.7575453355233, -122.492906676836) | |||
| 125717 | 125717 | 50788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 2 | 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) | |||
| 153072 | 153072 | 183411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985672.7267 | 2097039.7501 | 37.737243998747 | -122.49204891364201 | (37.737243998747, -122.492048913642) | |||
| 79803 | 79803 | 43861 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 2 | 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) | ||
| 46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
| 137052 | 137052 | 92395 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.8059 | 2099646.4846 | 37.7444081200554 | -122.491842887636 | (37.7444081200554, -122.491842887636) |
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 30623 | 30623 | 182368 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986188.3183 | 2104920.5503 | 37.758912670790004 | -122.490846021107 | (37.75891267079, -122.490846021107) | |||
| 133718 | 133718 | 182549 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986517.2893 | 2105614.7843 | 37.7608380588456 | -122.489759356723 | (37.7608380588456, -122.489759356723) | |||
| 25020 | 25020 | 182555 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986616.8854 | 2105696.0047 | 37.761066882292 | -122.489420874881 | (37.761066882292, -122.489420874881) | |||
| 186001 | 186001 | 95591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821001 | (37.7648163177268, -122.48948400821) |
| 161319 | 161319 | 181747 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987052.1054 | 2106842.9351 | 37.7642414343948 | -122.48799993277099 | (37.7642414343948, -122.487999932771) | |||
| 12106 | 12106 | 93458 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987115.9589 | 2098905.998 | 37.7424524797237 | -122.487196094011 | (37.7424524797237, -122.487196094011) | ||
| 13104 | 13104 | 93461 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987454.3807 | 2098917.8428 | 37.7425047306499 | -122.48602681673599 | (37.7425047306499, -122.486026816736) | ||
| 12048 | 12048 | 85994 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1886 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.5036 | 2102469.8058 | 37.7522634818033 | -122.485930912268 | (37.7522634818033, -122.485930912268) | ||
| 164468 | 164468 | 183845 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2237 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987595.6835 | 2100038.0171 | 37.745588665836 | -122.48562043042 | (37.745588665836, -122.48562043042) | |||
| 71684 | 71684 | 183874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2253 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5987600.3776 | 2099940.7208 | 37.7453217895816 | -122.485597059998 | (37.7453217895816, -122.485597059998) | |||
| 176116 | 176116 | 183842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2222 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5987636.2237 | 2100151.1028 | 37.745901531101396 | -122.485488547623 | (37.7459015311014, -122.485488547623) | |||
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 63491 | 63491 | 182127 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2636 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987775.8815 | 2098311.0525 | 37.7408573756578 | -122.484870670835 | (37.7408573756578, -122.484870670835) | |||
| 63492 | 63492 | 183936 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1817 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987778.87 | 2100975.0607 | 37.748172209816104 | -122.485055744578 | (37.7481722098161, -122.485055744578) | |||
| 101942 | 101942 | 45066 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 2 | 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) | |||
| 182993 | 182993 | 183558 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1610 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987922.2884 | 2097634.497 | 37.7390082581786 | -122.484314849379 | (37.7390082581786, -122.484314849379) | |||
| 10787 | 10787 | 86372 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.48468506709101 | (37.7630082536672, -122.484685067091) | ||
| 53825 | 53825 | 182065 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988018.43 | 2105853.6729 | 37.761581514586396 | -122.484585163984 | (37.7615815145864, -122.484585163984) | |||
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 24995 | 24995 | 181628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1290 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988037.8386 | 2106538.091 | 37.7634618698416 | -122.48456824258498 | (37.7634618698416, -122.484568242585) | |||
| 10873 | 10873 | 85952 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988060.095 | 2105875.8581 | 37.761644855373895 | -122.484442690808 | (37.7616448553739, -122.484442690808) | ||
| 11981 | 11981 | 86394 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1595 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988065.5212 | 2104481.6737 | 37.7578171200991 | -122.48432166889401 | (37.7578171200991, -122.484321668894) | ||
| 61486 | 61486 | 34637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38317 | 5988079.0097 | 2105334.7239 | 37.7601601497095 | -122.484337584053 | (37.7601601497095, -122.484337584053) | ||
| 184575 | 184575 | 182425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1538 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988098.2611 | 2104825.7625 | 37.758763800953005 | -122.484233676535 | (37.758763800953, -122.484233676535) | |||
| 136990 | 136990 | 182393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1554 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988100.204 | 2104724.7345 | 37.758486518599796 | -122.48421954804199 | (37.7584865185998, -122.484219548042) | |||
| 178351 | 178351 | 71165 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 4 | 5988190.2092 | 2100857.5067 | 37.747873389373396 | -122.48362474712499 | (37.7478733893734, -122.483624747125) | ||
| 168850 | 168850 | 92321 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2591 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52754 | 5988296.7898 | 2097687.1554 | 37.739174643542796 | -122.483023869558 | (37.7391746435428, -122.483023869558) |
| 12138 | 12138 | 86309 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1503 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.631 | 2105031.2185 | 37.7593430258366 | -122.483351727957 | (37.7593430258366, -122.483351727957) | ||
| 48718 | 48718 | 97494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.778288112363796 | -122.483770678777 | (37.7782881123638, -122.483770678777) | |
| 152143 | 152143 | 45042 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 6 | Permit Number 43928 | 5988487.0359 | 2102578.4714 | 37.7526159729384 | -122.48272444408998 | (37.7526159729384, -122.48272444409) | |
| 74143 | 74143 | 50554 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2231 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 3 | Permit Number 47178 | 5988525.9734 | 2100109.7092 | 37.7458396735364 | -122.482408920531 | (37.7458396735364, -122.482408920531) | ||
| 11444 | 11444 | 86329 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988529.8141 | 2100010.2791 | 37.7455668881622 | -122.48238835613998 | (37.7455668881622, -122.48238835614) | ||
| 136120 | 136120 | 183843 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2242 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988571.2077 | 2100055.5134 | 37.745693497424796 | -122.48224853862699 | (37.7456934974248, -122.482248538627) | |||
| 76990 | 76990 | 182137 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1499 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988663.091 | 2105183.6812 | 37.759779419906 | -122.482306481553 | (37.759779419906, -122.482306481553) | |||
| 70757 | 70757 | 182690 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1725 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988713.9908 | 2103546.8998 | 37.7552882198487 | -122.48201054093799 | (37.7552882198487, -122.482010540938) | |||
| 13151 | 13151 | 86202 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2395X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.6808 | 2099096.9051 | 37.7430788257671 | -122.48114283650101 | (37.7430788257671, -122.481142836501) | ||
| 167371 | 167371 | 182567 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2483 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988893.0118 | 2098438.9759 | 37.74127362251029 | -122.48101746001001 | (37.7412736225103, -122.48101746001) | |||
| 11620 | 11620 | 86115 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2490X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988938.6988 | 2098392.9506 | 37.7411499047667 | -122.480856123487 | (37.7411499047667, -122.480856123487) | ||
| 10464 | 10464 | 86111 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2544 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988952.3483 | 2098011.286 | 37.7401027466921 | -122.48078099378901 | (37.7401027466921, -122.480780993789) | ||
| 13038 | 13038 | 86102 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2602X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988967.6106 | 2097559.0789 | 37.7388619907591 | -122.480695127099 | (37.7388619907591, -122.480695127099) | ||
| 60645 | 60645 | 185813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1913 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989045.9651 | 2101702.9368 | 37.750244490673 | -122.480727500746 | (37.750244490673, -122.480727500746) | |||
| 27593 | 27593 | 82193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49858 | 5989080.382 | 2102109.5053 | 37.7513628201965 | -122.48063824575 | (37.7513628201965, -122.48063824575) | |
| 172286 | 172286 | 182571 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2208 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989133.5167 | 2098356.5835 | 37.7410613722493 | -122.480179859895 | (37.7410613722493, -122.480179859895) | |||
| 167724 | 167724 | 183420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1210 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989168.5817 | 2096994.6461 | 37.737323883205704 | -122.479958976444 | (37.7373238832057, -122.479958976444) | |||
| 76102 | 76102 | 183453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2519 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989212.7579 | 2098154.5204 | 37.7405111636594 | -122.4798910928 | (37.7405111636594, -122.4798910928) | |||
| 27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
| 135584 | 135584 | 183494 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2471 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989504.9089 | 2098548.5569 | 37.741610054481605 | -122.47890977280301 | (37.7416100544816, -122.478909772803) | |||
| 163864 | 163864 | 47758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2517 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 4 | Permit Number 45537 | 5989832.0192 | 2098195.9454 | 37.740660864188 | -122.477752978845 | (37.740660864188, -122.477752978845) | |
| 57315 | 57315 | 92291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2541 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52737 | 5989837.8157 | 2098042.3571 | 37.7402394868641 | -122.47772171282601 | (37.7402394868641, -122.477721712826) |
| 136442 | 136442 | 92293 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2551 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52738 | 5989840.1836 | 2097983.4983 | 37.7400780132426 | -122.47770922434799 | (37.7400780132426, -122.477709224348) |
| 119506 | 119506 | 45484 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3036 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44264 | 5990299.6759109 | 2095068.01075494 | 37.732099485445204 | -122.475907639335 | (37.7320994854452, -122.475907639335) | ||
| 69845 | 69845 | 214425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 41 Lagunitas Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991075.83745 | 2095563.72513 | 37.7335055639152 | -122.473260445626 | (37.7335055639152, -122.473260445626) | |||
| 123997 | 123997 | 69476 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1621 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33594 | 5991117.73448737 | 2104364.13999538 | 37.757671653787796 | -122.47375737618499 | (37.7576716537878, -122.473757376185) | ||
| 25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
| 19427 | 19427 | 51055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748001 | (37.746973143605, -122.47319139748) | |||
| 139093 | 139093 | 69478 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1642 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33596 | 5991208.59288317 | 2104157.90962907 | 37.757110661532 | -122.47342811182301 | (37.757110661532, -122.473428111823) | ||
| 156102 | 156102 | 214382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1935 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5991235.497140001 | 2102232.23855 | 37.751824832267395 | -122.473194631436 | (37.7518248322674, -122.473194631436) | |||
| 77408 | 77408 | 114870 | Planning Code 138.1 required 4 | Prunus serrulata :: Ornamental Cherry 35 | 2326 Cecelia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 3x4 | 5991484.88147917 | 2099641.61135178 | 37.744726077494995 | -122.472143418263 | (37.744726077495, -122.472143418263) | ||
| 86365 | 86365 | 47987 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2359 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | Permit Number 45719 | 5991665.05484131 | 2099376.71797109 | 37.7440091733338 | -122.471501121001 | (37.7440091733338, -122.471501121001) | |||
| 142824 | 142824 | 31920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 2 | 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) | ||
| 122844 | 122844 | 41857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 80073 | 80073 | 99924 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | |||
| 78985 | 78985 | 42571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42653 | 5992105.55983914 | 2095227.71522931 | 37.7326425353626 | -122.469675980927 | (37.7326425353626, -122.469675980927) | |||
| 95446 | 95446 | 47355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.942845901 | 2090329.99196799 | 37.7191993003756 | -122.46903830903099 | (37.7191993003756, -122.469038309031) | ||
| 19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 27000 | 27000 | 214389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992333.20147 | 2097526.08875 | 37.7389664461405 | -122.469056185189 | (37.7389664461405, -122.469056185189) | |||
| 143255 | 143255 | 67735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1339 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31354 | 5992372.79097163 | 2106335.64523608 | 37.763157498492205 | -122.46956043118 | (37.7631574984922, -122.46956043118) | ||
| 152260 | 152260 | 214387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2466 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992373.19537 | 2098669.75746 | 37.742108981343605 | -122.469001114305 | (37.7421089813436, -122.469001114305) | |||
| 113457 | 113457 | 50081 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46814 | 5992464.10513013 | 2098282.79530272 | 37.741051733622704 | -122.468658629771 | (37.7410517336227, -122.468658629771) | ||
| 128225 | 128225 | 35087 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1594 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38628 | 5992484.06042474 | 2104613.58351728 | 37.758435599993796 | -122.469050257237 | (37.7584355999938, -122.469050257237) |
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");