Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134629 | 134629 | 45072 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 580 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Permit Number 770844 | 6012040.04022 | 2105787.48822 | 37.7627694124935 | -122.401499066356 | (37.7627694124935, -122.401499066356) | |||
| 30529 | 30529 | 102468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998217.7 | 2104179.8 | 37.757574157371295 | -122.44918961776699 | (37.7575741573713, -122.449189617767) | |||||
| 122482 | 122482 | 103648 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X Oak Park Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 3x10 | 5994983.3 | 2103652.8 | 37.755941622135296 | -122.460337221652 | (37.7559416221353, -122.460337221652) | |||
| 118710 | 118710 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | |||
| 18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
| 109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
| 106097 | 106097 | 110277 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 HILIRITAS AVE | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6001414.0 | 2096889.0 | 37.7377376534528 | -122.437613416201 | (37.7377376534528, -122.437613416201) | ||||
| 78166 | 78166 | 111586 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 128803 | 128803 | 112187 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x CORBETT AVE | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 102089 | 102089 | 113091 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 398X ARBOR ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000747.0 | 2096921.0 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | ||||
| 104660 | 104660 | 113092 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598x ARBOR ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000747.0 | 2096921.0 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | ||||
| 113329 | 113329 | 113093 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598x ARBOR ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000747.0 | 2096921.0 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9669 | 9669 | 114126 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9666 | 9666 | 114127 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9671 | 9671 | 114132 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 117956 | 117956 | 114707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 28910 | 28910 | 114708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 89777 | 89777 | 114709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 83296 | 83296 | 114710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
| 137510 | 137510 | 118414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 641 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5980997.21538 | 2111360.64896 | 37.7762906814163 | -122.509277221064 | (37.7762906814163, -122.509277221064) | ||||
| 168002 | 168002 | 118630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 349 Point Lobos Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5981637.79887 | 2112651.0038099997 | 37.7798713628306 | -122.507157052361 | (37.7798713628306, -122.507157052361) | ||||
| 27038 | 27038 | 119401 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3150 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5985750.26334 | 2110481.7384 | 37.774156534172505 | -122.492770599571 | (37.7741565341725, -122.492770599571) | |||
| 72747 | 72747 | 119989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2750 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5986984.16114 | 2110526.5625 | 37.7743516837382 | -122.488505680665 | (37.7743516837382, -122.488505680665) | |||
| 159514 | 159514 | 121994 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5991309.65068 | 2111442.6825599996 | 37.7771185426669 | -122.47360999719601 | (37.7771185426669, -122.473609997196) | |||
| 167101 | 167101 | 121995 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991309.97219 | 2111418.90918 | 37.777053286089604 | -122.473607150419 | (37.7770532860896, -122.473607150419) | |||
| 134725 | 134725 | 122251 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990491.66042 | 2113417.49196 | 37.782493416539005 | -122.47658395887501 | (37.782493416539, -122.476583958875) | |||
| 161313 | 161313 | 122257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5991472.5237300005 | 2113448.5530000003 | 37.78263554306471 | -122.473192897736 | (37.7826355430647, -122.473192897736) | |||
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 120114 | 120114 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 86774 | 86774 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 71171 | 71171 | 123499 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2550 Fulton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5995451.11899 | 2110348.56887 | 37.7743533701225 | -122.459204202763 | (37.7743533701225, -122.459204202763) | |||
| 41152 | 41152 | 123500 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2550 Fulton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995440.159 | 2110347.2433700003 | 37.77434910054821 | -122.45924201914801 | (37.7743491005482, -122.459242019148) | |||
| 77186 | 77186 | 123502 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2550 Fulton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 5995414.62926 | 2110342.66795 | 37.7743350698735 | -122.459329999259 | (37.7743350698735, -122.459329999259) | |||
| 34543 | 34543 | 123503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2550 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 1ft | 5995405.4626400005 | 2110341.7489400003 | 37.774332019483296 | -122.459361641514 | (37.7743320194833, -122.459361641514) | |||
| 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) | |||
| 72912 | 72912 | 126411 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3398 Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6001324.1548 | 2120088.88928 | 37.8014336702784 | -122.439586737243 | (37.8014336702784, -122.439586737243) | |||
| 157404 | 157404 | 126412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6000088.69563 | 2121303.7240299997 | 37.804698887418105 | -122.443949299933 | (37.8046988874181, -122.443949299933) | |||
| 105567 | 105567 | 126413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Vallejo St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001029.975 | 2117557.6331599997 | 37.7944667608931 | -122.440423085162 | (37.7944667608931, -122.440423085162) | |||
| 53440 | 53440 | 126417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.42164030356301 | (37.8033669833519, -122.421640303563) | ||||
| 150704 | 150704 | 126418 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2237 Hyde St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6007090.48557 | 2119992.12642 | 37.8014944842289 | -122.41962574124099 | (37.8014944842289, -122.419625741241) | ||||
| 25143 | 25143 | 126422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 71 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 6008381.99212 | 2119124.63634 | 37.7991852374601 | -122.415095094385 | (37.7991852374601, -122.415095094385) | ||||
| 63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
| 39035 | 39035 | 126426 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3130 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999057.94156 | 2119543.59601 | 37.7998072004939 | -122.44738954670099 | (37.7998072004939, -122.447389546701) | |||
| 52668 | 52668 | 126427 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3130 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5999056.00761 | 2119563.15995 | 37.799860807300895 | -122.447397647786 | (37.7998608073009, -122.447397647786) | |||
| 180433 | 180433 | 126428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002587.87385 | 2120898.67704 | 37.803728977572604 | -122.43527166598 | (37.8037289775726, -122.43527166598) | |||
| 9720 | 9720 | 173652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 ZIRCON PL | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
| 132679 | 132679 | 181378 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984918.4209 | 2104448.6531 | 37.757542704393 | -122.49520305513201 | (37.757542704393, -122.495203055132) | |||
| 25480 | 25480 | 181380 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984920.3702 | 2104474.5517 | 37.757613928882606 | -122.49519822357901 | (37.7576139288826, -122.495198223579) | |||
| 63834 | 63834 | 181399 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984922.0411 | 2104649.9938 | 37.7580957419782 | -122.49520538251001 | (37.7580957419782, -122.49520538251) | |||
| 67847 | 67847 | 181403 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984902.868 | 2104683.3441 | 37.7581861900886 | -122.49527414976102 | (37.7581861900886, -122.495274149761) | |||
| 32582 | 32582 | 181404 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5984893.3996 | 2104690.5846 | 37.7582055161201 | -122.49530742906799 | (37.7582055161201, -122.495307429068) | |||
| 25921 | 25921 | 181412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984910.1084 | 2104727.9008 | 37.758308954313996 | -122.495252395507 | (37.758308954314, -122.495252395507) | |||
| 135866 | 135866 | 181413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984915.677999999 | 2104726.23 | 37.7583046928502 | -122.495233010459 | (37.7583046928502, -122.495233010459) | |||
| 52849 | 52849 | 181423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984896.1844 | 2104792.2296 | 37.758484768072904 | -122.49530529413 | (37.7584847680729, -122.49530529413) | |||
| 167760 | 167760 | 181426 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984929.045 | 2104818.9637 | 37.7585600964022 | -122.495193620608 | (37.7585600964022, -122.495193620608) | |||
| 65826 | 65826 | 181431 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984906.2097 | 2104856.8369 | 37.758662748720205 | -122.495275387185 | (37.7586627487202, -122.495275387185) | |||
| 122550 | 122550 | 181433 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984928.4881 | 2104916.9885 | 37.758829212628996 | -122.49520277524401 | (37.758829212629, -122.495202775244) | |||
| 147554 | 147554 | 181434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 63 | Width 0ft | 5984896.7414 | 2104905.8493 | 37.758796768768704 | -122.495311746922 | (37.7587967687687, -122.495311746922) | |||
| 137097 | 137097 | 181441 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984891.7288 | 2105036.7347 | 37.759155850149 | -122.49533873513501 | (37.759155850149, -122.495338735135) | |||
| 184501 | 184501 | 181442 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984907.8806 | 2105046.76 | 37.7591843225176 | -122.495283614644 | (37.7591843225176, -122.495283614644) | |||
| 23551 | 23551 | 181443 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984892.2857 | 2105061.2409 | 37.759223169955796 | -122.495338616437 | (37.7592231699558, -122.495338616437) | |||
| 35059 | 35059 | 181449 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984873.9061 | 2105087.418 | 37.759293968823705 | -122.49540411159401 | (37.7592939688237, -122.495404111594) | |||
| 170927 | 170927 | 181465 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984920.1337 | 2105218.8604 | 37.7596575796755 | -122.495253929823 | (37.7596575796755, -122.495253929823) | |||
| 41016 | 41016 | 181468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984882.2605 | 2105242.2526 | 37.7597195906535 | -122.49538663760599 | (37.7597195906535, -122.495386637606) | |||
| 149872 | 149872 | 181469 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984881.7035 | 2105250.0501 | 37.759740967801 | -122.495389139039 | (37.759740967801, -122.495389139039) | |||
| 177404 | 177404 | 181475 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984869.4504 | 2105277.3411 | 37.75981518382329 | -122.49543352861299 | (37.7598151838233, -122.495433528613) | |||
| 186166 | 186166 | 181496 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984867.2226 | 2105416.0239 | 37.7601958376586 | -122.495451461713 | (37.7601958376586, -122.495451461713) | |||
| 155838 | 155838 | 181502 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984910.6654 | 2105475.0616 | 37.7603604823662 | -122.495305569795 | (37.7603604823662, -122.495305569795) | |||
| 132817 | 132817 | 181506 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.5391 | 2105486.2008 | 37.76038813249 | -122.495479752328 | (37.76038813249, -122.495479752328) | |||
| 149399 | 149399 | 181508 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984873.9061 | 2105511.8209 | 37.760459260826295 | -122.495435412339 | (37.7604592608263, -122.495435412339) | |||
| 163323 | 163323 | 181509 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984883.3744 | 2105527.9727 | 37.7605041635582 | -122.495403857574 | (37.7605041635582, -122.495403857574) | |||
| 182159 | 182159 | 181511 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984874.1846 | 2105548.3017 | 37.7605594432249 | -122.495437139743 | (37.7605594432249, -122.495437139743) | |||
| 29359 | 29359 | 181512 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984867.501 | 2105563.3396 | 37.760600341747896 | -122.495461364037 | (37.7606003417479, -122.495461364037) | |||
| 63714 | 63714 | 181514 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5984875.8554 | 2105578.3775 | 37.7606421208046 | -122.49543357949301 | (37.7606421208046, -122.495433579493) | |||
| 165378 | 165378 | 181525 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984861.3745 | 2105743.7944 | 37.761095461476 | -122.49549586212 | (37.761095461476, -122.49549586212) | |||
| 76309 | 76309 | 181531 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984868.057999999 | 2105762.174 | 37.7611463180726 | -122.495474102719 | (37.7611463180726, -122.495474102719) | |||
| 147268 | 147268 | 181534 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984871.9567 | 2105787.2372 | 37.7612153629002 | -122.495462467531 | (37.7612153629002, -122.495462467531) | |||
| 77038 | 77038 | 181564 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5984848.6101 | 2106094.3132 | 37.7620571406013 | -122.495565861947 | (37.7620571406013, -122.495565861947) | |||
| 153876 | 153876 | 184003 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 0ft | 5984924.5288 | 2103681.69 | 37.7554371938568 | -122.49512537658998 | (37.7554371938568, -122.49512537659) | |||
| 50393 | 50393 | 184008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984916.8087 | 2103724.6456 | 37.755554686078206 | -122.49515524212799 | (37.7555546860782, -122.495155242128) | |||
| 130508 | 130508 | 184011 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984923.7934 | 2103740.8933 | 37.7555997066866 | -122.495132285287 | (37.7555997066866, -122.495132285287) | |||
| 161252 | 161252 | 184013 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984912.3213 | 2103745.8006 | 37.755612509136895 | -122.495172320671 | (37.7556125091369, -122.495172320671) | |||
| 180706 | 180706 | 184052 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984937.3498 | 2103855.5949 | 37.7559154391845 | -122.49509386136101 | (37.7559154391845, -122.495093861361) | |||
| 171921 | 171921 | 184062 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984941.4086 | 2103928.0299 | 37.7561145632567 | -122.49508516598499 | (37.7561145632567, -122.495085165985) | |||
| 152873 | 152873 | 184088 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 89 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984924.9202 | 2104112.1254 | 37.756619073195 | -122.49515576258999 | (37.756619073195, -122.49515576259) | |||
| 45664 | 45664 | 184092 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 95 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984922.9495 | 2104224.59 | 37.756927754428894 | -122.49517087102 | (37.7569277544289, -122.49517087102) | |||
| 42516 | 42516 | 184094 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 97 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984942.4654 | 2104248.1437 | 37.756993568912705 | -122.49510511552201 | (37.7569935689127, -122.495105115522) |
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");