Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 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) | |||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1030 | 1030 | 251424 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 5016 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1736 | 1736 | 251677 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772x Panorama Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996636.0 | 2102785.0 | 37.7536537924326 | -122.454558985212 | (37.7536537924326, -122.454558985212) | ||||
| 3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
| 3142 | 3142 | 217765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 5991548.70787 | 2096139.0246599999 | 37.7351125606845 | -122.471667523249 | (37.7351125606845, -122.471667523249) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 23418 | 23418 | 186415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984728.3813 | 2104210.7037 | 37.756878233428004 | -122.49584272637699 | (37.756878233428, -122.495842726377) | |||
| 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) | |||
| 23770 | 23770 | 186402 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | |||
| 23880 | 23880 | 187141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984898.7676 | 2099479.6664 | 37.7438980796356 | -122.494904654416 | (37.7438980796356, -122.494904654416) | |||
| 24028 | 24028 | 186361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | |||
| 24265 | 24265 | 184994 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984981.6045 | 2096535.6021 | 37.735819319769895 | -122.494401253367 | (37.7358193197699, -122.494401253367) | |||
| 24469 | 24469 | 186067 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984814.1882 | 2102091.1256 | 37.751063482205 | -122.495389663196 | (37.751063482205, -122.495389663196) | |||
| 24694 | 24694 | 206882 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 355 Parnassus Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 5996132.622880001 | 2106470.43448 | 37.7637441750665 | -122.456566260324 | (37.7637441750665, -122.456566260324) | |||
| 24834 | 24834 | 185543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 0ft | 5984873.6046 | 2099981.069 | 37.7452733220295 | -122.49502862542 | (37.7452733220295, -122.49502862542) | |||
| 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) | ||||
| 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) | |||
| 25632 | 25632 | 185934 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984996.9702 | 2101528.251 | 37.74952868337 | -122.494716099913 | (37.74952868337, -122.494716099913) | |||
| 25740 | 25740 | 187008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.739957538540295 | -122.49456132318899 | (37.7399575385403, -122.494561323189) | |||
| 25920 | 25920 | 205918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 5ft | 6000129.127169999 | 2095289.54923 | 37.7332727986918 | -122.441941059826 | (37.7332727986918, -122.441941059826) | |||
| 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) | |||
| 26008 | 26008 | 186451 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 0ft | 5984745.9677 | 2103899.5919999997 | 37.7560250369708 | -122.495758958747 | (37.7560250369708, -122.495758958747) | |||
| 26145 | 26145 | 185549 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984904.1167 | 2099896.1658 | 37.745041987094396 | -122.49491686223999 | (37.7450419870944, -122.49491686224) | |||
| 26275 | 26275 | 223757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5745 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6000755.6342 | 2096957.8752099997 | 37.7378893137452 | -122.439894635432 | (37.7378893137452, -122.439894635432) | |||
| 26631 | 26631 | 185883 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985034.4251 | 2101120.3406 | 37.7484108651264 | -122.494556514447 | (37.7484108651264, -122.494556514447) | |||
| 26684 | 26684 | 185578 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984888.727999999 | 2099615.9854 | 37.744271786934796 | -122.49494941784201 | (37.7442717869348, -122.494949417842) | |||
| 26770 | 26770 | 186065 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984846.241 | 2102114.0204 | 37.751128221750704 | -122.49528051122299 | (37.7511282217507, -122.495280511223) | |||
| 26964 | 26964 | 186346 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984814.4902 | 2102762.482 | 37.752906859827704 | -122.49543812761401 | (37.7529068598277, -122.495438127614) | |||
| 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) | |||
| 27053 | 27053 | 187052 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5984975.6777 | 2097633.6281 | 37.7388338582522 | -122.494502663013 | (37.7388338582522, -122.494502663013) | |||
| 27316 | 27316 | 187183 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984940.3895 | 2099200.21 | 37.74313320442471 | -122.494740138503 | (37.7431332044247, -122.494740138503) | |||
| 27513 | 27513 | 186961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5985200.1141 | 2096126.2386 | 37.7347081021486 | -122.493615636331 | (37.7347081021486, -122.493615636331) | |||
| 27837 | 27837 | 187145 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984892.4139 | 2099447.2487 | 37.743808697483395 | -122.49492423393801 | (37.7438086974834, -122.494924233938) | |||
| 27914 | 27914 | 186438 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984733.406 | 2103998.8295 | 37.756296779959996 | -122.495809720693 | (37.75629677996, -122.495809720693) | |||
| 28097 | 28097 | 184746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984670.325 | 2106153.0915 | 37.7622080878104 | -122.49618680876499 | (37.7622080878104, -122.496186808765) | |||
| 28368 | 28368 | 185036 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984991.2351 | 2096277.6682 | 37.7351116657323 | -122.494348950198 | (37.7351116657323, -122.494348950198) | |||
| 28570 | 28570 | 187221 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984920.4721 | 2098768.3716 | 37.7419463270938 | -122.494777174832 | (37.7419463270938, -122.494777174832) | |||
| 28666 | 28666 | 223807 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002423.3723 | 2097053.0195400002 | 37.7382453517447 | -122.434135255635 | (37.7382453517447, -122.434135255635) | |||
| 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) | ||||
| 29069 | 29069 | 186197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 66 | Width 0ft | 5984786.367000001 | 2103519.1304 | 37.7549827606067 | -122.49559118568399 | (37.7549827606067, -122.495591185684) | |||
| 29091 | 29091 | 186379 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984812.5721 | 2102477.6444 | 37.7521246619181 | -122.495423755128 | (37.7521246619181, -122.495423755128) | |||
| 29197 | 29197 | 186442 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5984767.7413 | 2103942.7205 | 37.756144730979294 | -122.49568684061 | (37.7561447309793, -122.49568684061) | |||
| 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) | |||
| 30477 | 30477 | 206884 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 355 Parnassus Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5996099.70651 | 2106459.36925 | 37.7637119028988 | -122.456679306927 | (37.7637119028988, -122.456679306927) | |||
| 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) | |||||
| 30698 | 30698 | 186366 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984834.9283 | 2102546.5983 | 37.7523152993529 | -122.49535152997 | (37.7523152993529, -122.49535152997) | |||
| 31264 | 31264 | 185017 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985031.8513 | 2096412.4973 | 37.735484247333396 | -122.494218462115 | (37.7354842473334, -122.494218462115) | |||
| 31709 | 31709 | 185542 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984918.1788 | 2099988.2327 | 37.745295600955295 | -122.494875025672 | (37.7452956009553, -122.494875025672) | |||
| 32009 | 32009 | 185077 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985040.4352 | 2096082.543 | 37.7345787830951 | -122.49416447312599 | (37.7345787830951, -122.494164473126) | |||
| 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) | |||
| 32968 | 32968 | 187010 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984953.6513 | 2098022.8732 | 37.7399013315107 | -122.494607506859 | (37.7399013315107, -122.494607506859) | |||
| 33235 | 33235 | 186398 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | Width 0ft | 5984807.1851 | 2102369.0959 | 37.751826302179104 | -122.495434378973 | (37.7518263021791, -122.495434378973) | |||
| 34251 | 34251 | 185991 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5984838.2048 | 2101005.2084 | 37.748083257257704 | -122.495226540797 | (37.7480832572577, -122.495226540797) | |||
| 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) | |||
| 34630 | 34630 | 205915 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000129.85009 | 2095267.01455 | 37.7332109649183 | -122.44193694363199 | (37.7332109649183, -122.441936943632) | |||
| 34686 | 34686 | 185644 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5985051.8314 | 2100455.4756 | 37.746586345742 | -122.49444732076401 | (37.746586345742, -122.494447320764) | |||
| 34831 | 34831 | 186018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5985010.437999999 | 2101834.6115 | 37.7503706537303 | -122.49469211198401 | (37.7503706537303, -122.494692111984) | |||
| 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) | |||
| 35232 | 35232 | 186940 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5985184.4751 | 2095979.7701 | 37.734305023711 | -122.49365891568 | (37.734305023711, -122.49365891568) | |||
| 35634 | 35634 | 187197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984932.9821 | 2099043.9135 | 37.7427036229391 | -122.49475423012899 | (37.7427036229391, -122.494754230129) | |||
| 35760 | 35760 | 223799 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8 Laidley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6003000.19412 | 2098305.51493 | 37.741717135947205 | -122.43223031618601 | (37.7417171359472, -122.432230316186) | ||||
| 35832 | 35832 | 185569 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5984875.7272 | 2099710.7055 | 37.74453110155571 | -122.495001354066 | (37.7445311015557, -122.495001354066) | |||
| 36089 | 36089 | 206844 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 488 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992249.47453 | 2091186.11142 | 37.72155360809921 | -122.46888442997299 | (37.7215536080992, -122.468884429973) | |||
| 36102 | 36102 | 186350 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 0ft | 5984802.9731 | 2102707.5748 | 37.7527554254133 | -122.49547390604499 | (37.7527554254133, -122.495473906045) | |||
| 36127 | 36127 | 184802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 0ft | 5984710.1955 | 2105740.9062 | 37.7610786777919 | -122.496018504161 | (37.7610786777919, -122.496018504161) | |||
| 36628 | 36628 | 186839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 83 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984830.1212 | 2106502.1656 | 37.7631759062792 | -122.49565989156099 | (37.7631759062792, -122.495659891561) | |||
| 36835 | 36835 | 205892 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997819.94601 | 2095725.4811900002 | 37.734337906251504 | -122.44995590246 | (37.7343379062515, -122.44995590246) | |||
| 37438 | 37438 | 223805 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002415.23965 | 2097063.15602 | 37.7382727226024 | -122.434164098718 | (37.7382727226024, -122.434164098718) | |||
| 37595 | 37595 | 205891 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5997820.03941 | 2095729.96315 | 37.73435021798711 | -122.44995590246201 | (37.7343502179871, -122.449955902462) | |||
| 37975 | 37975 | 206886 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 355 Parnassus Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5996058.56562 | 2106445.76375 | 37.76367218344 | -122.456820615576 | (37.76367218344, -122.456820615576) | |||
| 38102 | 38102 | 187181 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984923.7228 | 2099208.7285 | 37.7431556183483 | -122.49479839457199 | (37.7431556183483, -122.494798394572) | |||
| 38104 | 38104 | 186079 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984809.2191 | 2101997.6508 | 37.7508065351253 | -122.495399953486 | (37.7508065351253, -122.495399953486) | |||
| 38149 | 38149 | 186297 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984967.576 | 2102696.5961 | 37.7527349178342 | -122.494903878472 | (37.7527349178342, -122.494903878472) | |||
| 38386 | 38386 | 186162 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984944.9381 | 2103398.2721 | 37.75466020146371 | -122.495033898572 | (37.7546602014637, -122.495033898572) | |||
| 38529 | 38529 | 184787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984684.7543 | 2105859.3786 | 37.7614024796931 | -122.49611523377199 | (37.7614024796931, -122.496115233772) | |||
| 38550 | 38550 | 205889 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5997824.88709 | 2095746.51675 | 37.734395947598 | -122.449940335175 | (37.734395947598, -122.449940335175) | |||
| 38624 | 38624 | 223803 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002410.1357 | 2097069.9071099998 | 37.7382909698537 | -122.43418222813 | (37.7382909698537, -122.43418222813) |
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");