Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
| 16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
| 168599 | 168599 | 176157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5988327.5004199995 | 2088688.82584 | 37.714469318273004 | -122.482258598878 | (37.714469318273, -122.482258598878) | |||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 112771 | 112771 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 96 CRESTA VISTA DR | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.45765100803699 | (37.7352487002973, -122.457651008037) | ||||||
| 28068 | 28068 | 126421 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 6008400.762999999 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | ||||
| 70384 | 70384 | 126420 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6008389.07771 | 2118963.83905 | 37.798744126289 | -122.415059188055 | (37.798744126289, -122.415059188055) | ||||
| 157577 | 157577 | 126419 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 956 Vallejo St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008811.64334 | 2118703.9569599996 | 37.7980542914263 | -122.413578579305 | (37.7980542914263, -122.413578579305) | ||||
| 58718 | 58718 | 22877 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 113957 | 113957 | 22878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 3 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | ||
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 179404 | 179404 | 223742 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 921 Alvarado St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 8ft | 6000348.4325 | 2102535.54442 | 37.753181072867 | -122.441702702621 | (37.753181072867, -122.441702702621) | |||
| 5866 | 5866 | 14435 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3X3 | 5998902.8519 | 2113071.3194 | 37.7820271773983 | -122.447460087026 | (37.7820271773983, -122.447460087026) | |||
| 6783 | 6783 | 14432 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998887.9614 | 2113022.2482 | 37.781891589698894 | -122.44750806785801 | (37.7818915896989, -122.447508067858) | |||
| 144877 | 144877 | 120110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Knollview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x25 | 5997618.0 | 2101448.0 | 37.750038994650396 | -122.45106661992399 | (37.7500389946504, -122.451066619924) | |||
| 28508 | 28508 | 206910 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Valdez Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5996121.33012 | 2094628.67592 | 37.7312290039204 | -122.455749275714 | (37.7312290039204, -122.455749275714) | |||
| 67588 | 67588 | 206909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Valdez Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5996115.85771 | 2094634.73761 | 37.7312453337995 | -122.455768632716 | (37.7312453337995, -122.455768632716) | |||
| 24024 | 24024 | 206902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996057.83075 | 2094626.65779 | 37.7312198182223 | -122.45596865725 | (37.7312198182223, -122.45596865725) | |||
| 26174 | 26174 | 206899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996026.341440001 | 2094620.2534900003 | 37.731200426151794 | -122.456077057924 | (37.7312004261518, -122.456077057924) | |||
| 39316 | 39316 | 206908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5996107.30709 | 2094636.40332 | 37.7312494167135 | -122.455798313936 | (37.7312494167135, -122.455798313936) | |||
| 43231 | 43231 | 206900 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996039.46255 | 2094622.9528599998 | 37.731208591101705 | -122.45603189126699 | (37.7312085911017, -122.456031891267) | |||
| 46806 | 46806 | 206904 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996071.34052 | 2094630.09255 | 37.73123002464121 | -122.45592220005301 | (37.7312300246412, -122.455922200053) | |||
| 48614 | 48614 | 206903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996066.09368 | 2094629.08698 | 37.7312269624471 | -122.455940266542 | (37.7312269624471, -122.455940266542) | |||
| 162086 | 162086 | 206906 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996084.83474 | 2094632.7841400001 | 37.7312381895837 | -122.455875742899 | (37.7312381895837, -122.455875742899) | |||
| 165618 | 165618 | 206905 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996075.8178 | 2094629.9989599998 | 37.731230024636105 | -122.455906714624 | (37.7312300246361, -122.455906714624) | |||
| 175611 | 175611 | 206907 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5996091.97052 | 2094634.86515 | 37.731244313077895 | -122.455851223752 | (37.7312443130779, -122.455851223752) | |||
| 187143 | 187143 | 206901 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996051.82187 | 2094624.9249900002 | 37.7312147154845 | -122.45598930567199 | (37.7312147154845, -122.455989305672) | |||
| 107501 | 107501 | 115835 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X LAKE MERCED BLVD | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | ||
| 111885 | 111885 | 115833 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | ||
| 18578 | 18578 | 29625 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991156.8644 | 2090780.0583900001 | 37.7203755006984 | -122.472631660317 | (37.7203755006984, -122.472631660317) | ||
| 19930 | 19930 | 29624 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991155.39463 | 2090794.87778 | 37.720416106010795 | -122.472637820699 | (37.7204161060108, -122.472637820699) | ||
| 20248 | 20248 | 29611 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991160.04623 | 2090951.2024400001 | 37.72084560421371 | -122.47263313341499 | (37.7208456042137, -122.472633133415) | ||
| 20640 | 20640 | 29609 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.14351 | 2091025.81173 | 37.7210511631493 | -122.472596754032 | (37.7210511631493, -122.472596754032) | ||
| 21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
| 21913 | 21913 | 29618 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991164.47662 | 2090887.5563700001 | 37.720671104264 | -122.47261318107799 | (37.720671104264, -122.472613181078) | ||
| 22262 | 22262 | 29593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.05944 | 2091153.1258900003 | 37.7214011945921 | -122.47257866867201 | (37.7214011945921, -122.472578668672) | ||
| 28705 | 28705 | 206872 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991149.64989 | 2090725.7488 | 37.7202259623434 | -122.47265264062 | (37.7202259623434, -122.47265264062) | |||
| 43604 | 43604 | 206874 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5991143.093090001 | 2090605.8468900002 | 37.7198963617096 | -122.472666567502 | (37.7198963617096, -122.472666567502) | |||
| 43611 | 43611 | 206876 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 107 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991129.63237 | 2090361.82623 | 37.7192255618863 | -122.472695313452 | (37.7192255618863, -122.472695313452) | |||
| 52900 | 52900 | 206875 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 102 | : 4 | Tree 1 | Private 1 | 26 | Width 0ft | 5991134.69079 | 2090432.70427 | 37.71942046834911 | -122.472682993629 | (37.7194204683491, -122.472682993629) | |||
| 67313 | 67313 | 206873 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 42 | : 4 | Tree 1 | Private 1 | 26 | Width 0ft | 5991154.924219999 | 2090716.21418 | 37.720200087933605 | -122.47263371439101 | (37.7202000879336, -122.472633714391) | |||
| 186983 | 186983 | 206877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 112 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991127.9538900005 | 2090310.3975099998 | 37.7190842541173 | -122.472697367507 | (37.7190842541173, -122.472697367507) | |||
| 28511 | 28511 | 176155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 9 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5988052.58895 | 2088755.4955 | 37.71463638173179 | -122.48321367528798 | (37.7146363817318, -122.483213675288) | |||
| 36171 | 36171 | 176154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5987807.09848 | 2088773.10862 | 37.714670453457295 | -122.48406347077801 | (37.7146704534573, -122.484063470778) | |||
| 40889 | 40889 | 176156 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 10 | : 4 | Tree 1 | Private 1 | 31 | Width 0ft | 5988097.715469999 | 2088752.8411700001 | 37.714631719660396 | -122.48305750709801 | (37.7146317196604, -122.483057507098) | |||
| 140124 | 140124 | 176152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5987747.4162 | 2088772.85017 | 37.7146662689143 | -122.48426973566099 | (37.7146662689143, -122.484269735661) | |||
| 166286 | 166286 | 176153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5987778.038380001 | 2088773.7248200001 | 37.7146704534554 | -122.484163958296 | (37.7146704534554, -122.484163958296) | |||
| 5089 | 5089 | 253778 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 5095 | 5095 | 253779 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 5100 | 5100 | 253781 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 5107 | 5107 | 253780 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 184868 | 184868 | 205876 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 9 Locksley Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5994093.62789 | 2104819.10263 | 37.7590927708292 | -122.463498614174 | (37.7590927708292, -122.463498614174) | |||
| 869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 157593 | 157593 | 124179 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 1609 | 1609 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1628 | 1628 | 251629 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1629 | 1629 | 251631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
| 13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 40530 | 40530 | 205896 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995555.85476 | 2096185.3340599998 | 37.73547073996521 | -122.457816813517 | (37.7354707399652, -122.457816813517) | |||
| 53358 | 53358 | 250696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5985597.38635 | 2114946.90963 | 37.786407669826495 | -122.493628505377 | (37.7864076698265, -122.493628505377) | |||
| 176606 | 176606 | 250697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5985607.20317 | 2114948.81702 | 37.7864134812469 | -122.493594682746 | (37.7864134812469, -122.493594682746) | |||
| 180025 | 180025 | 250698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5985618.29441 | 2114950.69693 | 37.78641929175679 | -122.49355644897601 | (37.7864192917568, -122.493556448976) | |||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 122333 | 122333 | 97685 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 84 Coventry Ct | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997084.0 | 2096485.0 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | ||||||
| 77466 | 77466 | 110865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 838 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 6x9 | 5985433.60853 | 2110167.44818 | 37.7732750611072 | -122.49384278286699 | (37.7732750611072, -122.493842782867) | |||
| 41942 | 41942 | 176158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 825 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5989484.91598 | 2088634.67131 | 37.7143878792713 | -122.47825419477199 | (37.7143878792713, -122.478254194772) | |||
| 173594 | 173594 | 118511 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8131 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 5981763.277969999 | 2112328.08269 | 37.7789921064061 | -122.506699014872 | (37.7789921064061, -122.506699014872) | |||
| 88589 | 88589 | 114269 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 91685 | 91685 | 114268 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 114769 | 114769 | 114267 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 124433 | 124433 | 114265 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 26 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
| 11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
| 12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
| 80604 | 80604 | 109658 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 94555 | 94555 | 109656 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||
| 94669 | 94669 | 109654 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 94728 | 94728 | 109655 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 97780 | 97780 | 109648 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 102772 | 102772 | 109653 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 109323 | 109323 | 109649 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 109927 | 109927 | 109657 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 110258 | 110258 | 109650 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 111096 | 111096 | 109659 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 142047 | 142047 | 109652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 145583 | 145583 | 109651 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
| 25637 | 25637 | 190976 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011280.21235 | 2104227.17617 | 37.758442718371704 | -122.404017246303 | (37.7584427183717, -122.404017246303) | ||||
| 32368 | 32368 | 190972 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011274.67248 | 2104298.88872 | 37.758639315564 | -122.404041452454 | (37.758639315564, -122.404041452454) | ||||
| 35184 | 35184 | 190969 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6011271.58164 | 2104330.23228 | 37.758725205314704 | -122.404054347838 | (37.7587252053147, -122.404054347838) | ||||
| 39647 | 39647 | 190975 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6011275.59974 | 2104245.89235 | 37.758493851126296 | -122.40403451598 | (37.7584938511263, -122.40403451598) | ||||
| 57404 | 57404 | 190967 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | 6011275.2709 | 2104408.12846 | 37.7589392970181 | -122.404047070529 | (37.7589392970181, -122.404047070529) | ||||
| 126894 | 126894 | 190968 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011276.3148 | 2104337.18505 | 37.7587445605265 | -122.40403846760799 | (37.7587445605265, -122.404038467608) | ||||
| 152251 | 152251 | 190977 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | 6011279.98561 | 2104216.03333 | 37.7584121099421 | -122.40401724631799 | (37.7584121099421, -122.404017246318) | ||||
| 152747 | 152747 | 190970 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011272.79136 | 2104320.91829 | 37.758699698760296 | -122.40404950858 | (37.7586996987603, -122.40404950858) | ||||
| 173530 | 173530 | 190974 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6011278.73233 | 2104250.4136900003 | 37.7585064407439 | -122.404024000205 | (37.7585064407439, -122.404024000205) | ||||
| 175510 | 175510 | 190973 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 6011275.27355 | 2104274.28266 | 37.7585717863791 | -122.404037642038 | (37.7585717863791, -122.404037642038) |
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");