Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 34311 | 34311 | 67662 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.38719389035101 | (37.739521017402, -122.387193890351) | ||
| 149041 | 149041 | 46629 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1490 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 7 | Permit Number 44750 | 6015847.6531 | 2095265.1212 | 37.734088902667104 | -122.38759560956001 | (37.7340889026671, -122.38759560956) | |
| 59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
| 63659 | 63659 | 38558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.735249514063895 | -122.38798439240601 | (37.7352495140639, -122.387984392406) | ||
| 159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
| 114922 | 114922 | 51808 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48055 | 6015124.97012751 | 2092940.21442791 | 37.727665120823495 | -122.38993182362302 | (37.7276651208235, -122.389931823623) | |||
| 103592 | 103592 | 121759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015338.0 | 2103772.0 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | ||||
| 156664 | 156664 | 51809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48055 | 6015110.437000001 | 2092946.715 | 37.7276821641004 | -122.389982519172 | (37.7276821641004, -122.389982519172) | |
| 133911 | 133911 | 60295 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1469 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1982 12:00:00 AM | 7 | 3x3 | Permit Number 19860 | 6015087.9595 | 2092963.5731 | 37.727727206447604 | -122.390061402044 | (37.7277272064476, -122.390061402044) | |
| 54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
| 80506 | 80506 | 27758 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 83929 | 83929 | 27750 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 118003 | 118003 | 27753 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 126737 | 126737 | 27754 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 96146 | 96146 | 29251 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
| 124164 | 124164 | 27720 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
| 46253 | 46253 | 27745 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.852606599 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | ||
| 104005 | 104005 | 27743 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1399 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.852606599 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | ||
| 99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
| 172828 | 172828 | 30770 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1662 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | Permit Number 51077 | 6014463.7744 | 2093152.8983 | 37.7282124168861 | -122.39223247286101 | (37.7282124168861, -122.392232472861) | ||
| 167759 | 167759 | 196407 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6014364.2295 | 2105674.4780599996 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | |||
| 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) | |||
| 128168 | 128168 | 40229 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 South Park | 4 | 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) | |||
| 123154 | 123154 | 4019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1760 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.39453736171801 | (37.7499162221241, -122.394537361718) | ||
| 160610 | 160610 | 67707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.9587900005 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) | |
| 95103 | 95103 | 64483 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 55X Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | Permit Number 25357 | 6014099.57937836 | 2112818.90611884 | 37.782190816387796 | -122.394868269842 | (37.7821908163878, -122.394868269842) | ||
| 159092 | 159092 | 196393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013990.372330001 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | |||
| 57720 | 57720 | 196392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013963.537140001 | 2112927.48749 | 37.7824813907387 | -122.39534652723499 | (37.7824813907387, -122.395346527235) | |||
| 177156 | 177156 | 196391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | |||
| 54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 120359 | 120359 | 32267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 267 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36853 | 6013772.46926434 | 2105862.13808331 | 37.7630708975316 | -122.395512392676 | (37.7630708975316, -122.395512392676) | |||
| 154435 | 154435 | 196388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013913.95715 | 2112880.07634 | 37.782348452967206 | -122.395514731015 | (37.7823484529672, -122.395514731015) | |||
| 156919 | 156919 | 196387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013895.88765 | 2112864.3036700003 | 37.782304139751794 | -122.39557613855301 | (37.7823041397518, -122.395576138553) | |||
| 133506 | 133506 | 196386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | |||
| 177545 | 177545 | 196385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013873.09616 | 2112844.01572 | 37.7822471659153 | -122.395653565657 | (37.7822471659153, -122.395653565657) | |||
| 100203 | 100203 | 44089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | |
| 124052 | 124052 | 44088 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | |
| 46066 | 46066 | 67709 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | ||
| 48475 | 48475 | 196394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 497 03rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.781335479998496 | -122.39604324912202 | (37.7813354799985, -122.396043249122) | |||
| 15620 | 15620 | 44090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013747.9947 | 2112490.5876700003 | 37.7812697737139 | -122.39606158808701 | (37.7812697737139, -122.396061588087) | |
| 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) | |||
| 14002 | 14002 | 44086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013734.19002 | 2112474.65205 | 37.7812252500735 | -122.396108228707 | (37.7812252500735, -122.396108228707) | |
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
| 119406 | 119406 | 4026 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 121773 | 121773 | 4025 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 123464 | 123464 | 4023 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 77817 | 77817 | 67647 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.736394256512206 | -122.39668225739901 | (37.7363942565122, -122.396682257399) | ||
| 170429 | 170429 | 178896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012763.5947 | 2086999.9849599998 | 37.711223202768295 | -122.397678716599 | (37.7112232027683, -122.397678716599) | |||
| 35382 | 35382 | 40325 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1999 12:00:00 AM | 4 | Permit Number 41463 | 6013209.4791 | 2113639.3788 | 37.78439411283129 | -122.39800521351201 | (37.7843941128313, -122.398005213512) | ||
| 37685 | 37685 | 178897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.39803135517599 | (37.7120669530014, -122.398031355176) | |||
| 164638 | 164638 | 178898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | |||
| 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) | |||
| 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) | ||
| 107830 | 107830 | 4033 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 125081 | 125081 | 4027 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 143514 | 143514 | 4029 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 80354 | 80354 | 67682 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31286 | 6012201.16288031 | 2095460.48706817 | 37.73442268368721 | -122.400216460292 | (37.7344226836872, -122.400216460292) | ||
| 171467 | 171467 | 196377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.40065055237899 | (37.7808597440141, -122.400650552379) | |||
| 78614 | 78614 | 196378 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012410.6733800005 | 2112360.21924 | 37.78083731581879 | -122.400678929615 | (37.7808373158188, -122.400678929615) | |||
| 184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
| 163292 | 163292 | 196380 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012381.80562 | 2112329.94836 | 37.780752588889705 | -122.40077667062599 | (37.7807525888897, -122.400776670626) | |||
| 55206 | 55206 | 196381 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | |||
| 138811 | 138811 | 43293 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43062 | 6012196.286885 | 2103939.61174077 | 37.7577042695859 | -122.40082883013599 | (37.7577042695859, -122.400828830136) | ||
| 126294 | 126294 | 43292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 969 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43061 | 6012193.84203757 | 2103983.88594083 | 37.75782570042529 | -122.400840395966 | (37.7578257004253, -122.400840395966) | ||
| 148188 | 148188 | 196382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012355.92865 | 2112312.32296 | 37.780702750265704 | -122.400864953468 | (37.7807027502657, -122.400864953468) | |||
| 168201 | 168201 | 38758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012273.2979999995 | 2112461.93462 | 37.7811089398776 | -122.401161330453 | (37.7811089398776, -122.401161330453) | ||
| 178028 | 178028 | 38750 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012258.40846 | 2112446.8085 | 37.7810665763953 | -122.40121177791 | (37.7810665763953, -122.40121177791) | ||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 130997 | 130997 | 38752 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012228.62933 | 2112416.55663 | 37.780981850378105 | -122.40131267285 | (37.7809818503781, -122.40131267285) | ||
| 159980 | 159980 | 196374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012209.830030001 | 2112433.27452 | 37.7810267049661 | -122.40137888454201 | (37.7810267049661, -122.401378884542) | |||
| 74536 | 74536 | 196375 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012200.498790001 | 2112422.5734200003 | 37.7809968015951 | -122.401410413864 | (37.7809968015951, -122.401410413864) | |||
| 29397 | 29397 | 38753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.780869712107396 | -122.40145140226002 | (37.7808697121074, -122.40145140226) | ||
| 187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) | |||
| 37281 | 37281 | 38754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012174.72166 | 2112365.01303 | 37.7808373158384 | -122.40149554368901 | (37.7808373158384, -122.401495543689) | ||
| 155512 | 155512 | 196383 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 172 Clara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012113.23171 | 2112074.9324 | 37.780037390439794 | -122.40168787361799 | (37.7800373904398, -122.401687873618) | |||
| 77426 | 77426 | 91342 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 79690 | 79690 | 91341 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 138531 | 138531 | 91340 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 145257 | 145257 | 48941 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46128 | 6011661.44049501 | 2091503.35733972 | 37.7235271168325 | -122.401804405977 | (37.7235271168325, -122.401804405977) | ||
| 88065 | 88065 | 34303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38091 | 6011656.31212487 | 2091520.16541192 | 37.7235729821535 | -122.40182331486 | (37.7235729821535, -122.40182331486) | ||
| 106934 | 106934 | 48938 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1213 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46126 | 6011656.06397948 | 2091520.97870067 | 37.7235752014293 | -122.40182422980101 | (37.7235752014293, -122.401824229801) | ||
| 95411 | 95411 | 48937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47623 | 6011655.9812658 | 2091521.24979215 | 37.7235759411749 | -122.401824534776 | (37.7235759411749, -122.401824534776) | ||
| 144364 | 144364 | 51585 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2310@ KANSAS 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | Permit Number 47878 | 6011640.45005076 | 2101375.04283717 | 37.7506315072329 | -122.40257081531401 | (37.7506315072329, -122.402570815314) | |||
| 80278 | 80278 | 42211 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.40260952625201 | (37.7783260063796, -122.402609526252) | ||
| 125151 | 125151 | 42210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 937 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.40260952625201 | (37.7783260063796, -122.402609526252) | ||
| 127195 | 127195 | 38189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | ||
| 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) |
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");