Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2757 | 2757 | 253210 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 567 Mississippi St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2104519.0 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | |||||
| 81073 | 81073 | 101977 | Property Tree 7 | Cedrus deodara :: Deodar Cedar 129 | 601 Grand View Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000076.2 | 2101609.9 | 37.750623962991796 | -122.44257767940901 | (37.7506239629918, -122.442577679409) | ||||||
| 3261 | 3261 | 253388 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 30 Grand View Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 4916 | 4916 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767.0 | 2107205.0 | 37.7659690994291 | -122.44404889486401 | (37.7659690994291, -122.444048894864) | |
| 22304 | 22304 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 Oakdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.39108575959101 | (37.7349525388235, -122.391085759591) | |||||
| 25728 | 25728 | 185858 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2000 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985012.4452 | 2100952.2478 | 37.747948041708206 | -122.494620128976 | (37.7479480417082, -122.494620128976) | |||
| 32376 | 32376 | 205963 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1575 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 3ft | 5995549.162409999 | 2094435.18175 | 37.730664862775996 | -122.45771335370002 | (37.730664862776, -122.4577133537) | |||
| 33117 | 33117 | 205969 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5992083.35814 | 2100504.34625 | 37.7471295420093 | -122.470136830344 | (37.7471295420093, -122.470136830344) | |||
| 34871 | 34871 | 222769 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 81 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002596.6945400005 | 2097696.2545 | 37.740021361702 | -122.433581950462 | (37.740021361702, -122.433581950462) | ||||
| 36099 | 36099 | 188431 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 889 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6011294.06359 | 2104194.03596 | 37.7583524966 | -122.403967010163 | (37.7583524966, -122.403967010163) | ||||
| 37112 | 37112 | 222759 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 25 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5997031.40026 | 2106439.64122 | 37.763711185252795 | -122.453455459504 | (37.7637111852528, -122.453455459504) | |||
| 41353 | 41353 | 186969 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 2550x Yorba St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 5985198.4325 | 2096209.9829 | 37.7349379433341 | -122.493627618821 | (37.7349379433341, -122.493627618821) | |||
| 45071 | 45071 | 222767 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 301 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5999265.865019999 | 2105880.9438099996 | 37.7623049720107 | -122.44568698528299 | (37.7623049720107, -122.445686985283) | |||
| 45475 | 45475 | 187553 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3960 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011370.897059999 | 2088323.0132400002 | 37.7147783208511 | -122.40258523064199 | (37.7147783208511, -122.402585230642) | ||||
| 45776 | 45776 | 205958 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1711 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993391.35937 | 2103817.45791 | 37.75630202704129 | -122.465854594221 | (37.7563020270413, -122.465854594221) | |||
| 50261 | 50261 | 188435 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 47 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013897.60555 | 2093909.5086 | 37.730258461857 | -122.39424270564301 | (37.730258461857, -122.394242705643) | |||
| 65588 | 65588 | 222763 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 324 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003511.54798 | 2104505.04624 | 37.758768575130404 | -122.43090456708799 | (37.7587685751304, -122.430904567088) | |||
| 69660 | 69660 | 205959 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1501 05th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5994575.87769 | 2105238.79238 | 37.760272904392096 | -122.461861209523 | (37.7602729043921, -122.461861209523) | ||||
| 69818 | 69818 | 205973 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 100 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994796.55724 | 2098924.8239 | 37.742949049753896 | -122.460640430205 | (37.7429490497539, -122.460640430205) | |||
| 81071 | 81071 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 970 GUERRERO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005649.9 | 2103318.5 | 37.755631523761394 | -122.42342479955799 | (37.7556315237614, -122.423424799558) | ||||
| 83923 | 83923 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 617 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50213 | 6003760.0 | 2104634.0 | 37.7591367256626 | -122.43005450480699 | (37.7591367256626, -122.430054504807) | ||||
| 85687 | 85687 | 113112 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014731.0 | 2095647.0 | 37.735075549566204 | -122.391482947841 | (37.7350755495662, -122.391482947841) | |||||
| 87015 | 87015 | 51490 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1141 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | Permit Number 47801 | 6006346.62176787 | 2120383.49035499 | 37.802527140798205 | -122.42222766993 | (37.8025271407982, -122.42222766993) | |||
| 96023 | 96023 | 113237 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 700X JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5991325.0 | 2093086.0 | 37.726716776202295 | -122.472218478241 | (37.7267167762023, -122.472218478241) | ||||
| 102548 | 102548 | 101898 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 102574 | 102574 | 67845 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 4175 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1993 12:00:00 AM | 3x3 | Permit Number 767162 | 6002749.4858836 | 2100326.5930757 | 37.74725232675571 | -122.433241561015 | (37.7472523267557, -122.433241561015) | ||
| 107541 | 107541 | 109412 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 24 DELMAR ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774367 | 5999307.7 | 2108197.1 | 37.768666944455795 | -122.445708866914 | (37.7686669444558, -122.445708866914) | |
| 110220 | 110220 | 89552 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 5301X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982134.082169999 | 2111641.44969 | 37.777128641393205 | -122.50536536973101 | (37.7771286413932, -122.505365369731) | ||
| 115954 | 115954 | 222764 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 191 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000158.84379 | 2105641.525 | 37.76169853039 | -122.442581324981 | (37.76169853039, -122.442581324981) | |||
| 116836 | 116836 | 108587 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 950 Goettingen St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6011025.0 | 2090361.0 | 37.7203549001646 | -122.40392412914801 | (37.7203549001646, -122.403924129148) | |||||
| 117224 | 117224 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 731 CLAYTON ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5998515.0 | 2108057.0 | 37.768236974715705 | -122.44844065135099 | (37.7682369747157, -122.448440651351) | |||||
| 118617 | 118617 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1526 MASONIC AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x6 | 5999767.0 | 2107205.0 | 37.7659690994291 | -122.44404889486401 | (37.7659690994291, -122.444048894864) | ||||
| 120246 | 120246 | 4264 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 4175 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6002749.5486029005 | 2100327.5979009997 | 37.7472550893281 | -122.433241415923 | (37.7472550893281, -122.433241415923) | |||
| 120839 | 120839 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016814.0 | 2097238.0 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | |||||
| 120885 | 120885 | 222761 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3995 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003074.11018 | 2104735.69559 | 37.75937708790379 | -122.43243390111999 | (37.7593770879038, -122.43243390112) | |||
| 124585 | 124585 | 100843 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 131487 | 131487 | 181855 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2321 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5986995.4808 | 2099452.2108 | 37.7439452086002 | -122.487652784151 | (37.7439452086002, -122.487652784151) | |||
| 135522 | 135522 | 188428 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 437 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6011224.31071 | 2106297.23257 | 37.7641235064287 | -122.404356282613 | (37.7641235064287, -122.404356282613) | |||
| 145758 | 145758 | 121091 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 30X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 147897 | 147897 | 187545 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1399 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011375.77756 | 2088317.82522 | 37.714764348070204 | -122.40256799691002 | (37.7147643480702, -122.40256799691) | ||||
| 152940 | 152940 | 122533 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 330 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5996206.76468 | 2115142.22456 | 37.787558891067796 | -122.456937093983 | (37.7875588910678, -122.456937093983) | |||
| 154241 | 154241 | 222765 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 272 Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 5999637.29501 | 2105376.06979 | 37.760939912666004 | -122.444366068238 | (37.760939912666, -122.444366068238) | |||
| 162259 | 162259 | 181368 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1500 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984948.7535 | 2104361.5119 | 37.7573052146707 | -122.4950917287 | (37.7573052146707, -122.4950917287) | |||
| 162430 | 162430 | 185070 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 2550x Yorba St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 5985042.3194 | 2096218.4188 | 37.7349519720941 | -122.49416797038602 | (37.7349519720941, -122.494167970386) | |||
| 164724 | 164724 | 187547 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1398 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6011342.64618 | 2088318.4988900002 | 37.71476434807511 | -122.402682560663 | (37.7147643480751, -122.402682560663) | ||||
| 165282 | 165282 | 222754 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1319 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009549.26243 | 2101463.4019299997 | 37.7507571508265 | -122.409808579911 | (37.7507571508265, -122.409808579911) | |||
| 169579 | 169579 | 187557 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3959 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6011334.94928 | 2088323.74418 | 37.71477832084229 | -122.40270953314301 | (37.7147783208423, -122.402709533143) | ||||
| 170070 | 170070 | 125944 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 100 Alice B Toklas Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006919.44761 | 2114149.75866 | 37.785443161324395 | -122.419802815953 | (37.7854431613244, -122.419802815953) | |||
| 170245 | 170245 | 205970 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 100 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998533.62176 | 2097061.4424400001 | 37.7380469478033 | -122.447584640212 | (37.7380469478033, -122.447584640212) | |||
| 172237 | 172237 | 125943 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 90 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | 6008175.06816 | 2119117.82547 | 37.799154906033 | -122.415810641761 | (37.799154906033, -122.415810641761) | ||||
| 177776 | 177776 | 188429 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 449 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 6011226.32469 | 2106249.13843 | 37.7639915632946 | -122.40434593142 | (37.7639915632946, -122.40434593142) | |||
| 185053 | 185053 | 205974 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 645 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998776.7097 | 2095073.04363 | 37.732601166099 | -122.44660114792299 | (37.732601166099, -122.446601147923) | ||||
| 187577 | 187577 | 205961 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 600x Wildwood Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5995381.06521 | 2093316.38835 | 37.7275832683311 | -122.458213544042 | (37.7275832683311, -122.458213544042) | ||||
| 24901 | 24901 | 188434 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 406 Arkansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6012917.44565 | 2105140.82493 | 37.7610427357449 | -122.39841903400499 | (37.7610427357449, -122.398419034005) | |||
| 28558 | 28558 | 222770 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 81 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002588.1649 | 2097709.69049 | 37.74005776985221 | -122.43361240240401 | (37.7400577698522, -122.433612402404) | ||||
| 35878 | 35878 | 185943 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2001 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984815.4773 | 2101526.8869 | 37.7495143130094 | -122.49534359796999 | (37.7495143130094, -122.49534359797) | |||
| 42380 | 42380 | 222758 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 671 28th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6001587.480280001 | 2099382.86516 | 37.7445950851959 | -122.43719212141899 | (37.7445950851959, -122.437192121419) | |||
| 45674 | 45674 | 125941 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 330 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5996203.89662 | 2115167.13558 | 37.7876271253444 | -122.456948819342 | (37.7876271253444, -122.456948819342) | |||
| 54507 | 54507 | 205968 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5992072.49202 | 2100505.518 | 37.74713213114129 | -122.470174489472 | (37.7471321311413, -122.470174489472) | |||
| 67813 | 67813 | 187548 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1398 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6011346.78154 | 2088306.58257 | 37.7147318591505 | -122.402667429564 | (37.7147318591505, -122.402667429564) | ||||
| 68793 | 68793 | 188430 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 895 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6011323.63457 | 2104185.0777 | 37.758329551292704 | -122.403864109736 | (37.7583295512927, -122.403864109736) | ||||
| 82723 | 82723 | 102522 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1X 31st St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 5999966.2 | 2097547.4 | 37.7394630398899 | -122.442666404233 | (37.7394630398899, -122.442666404233) | |||||
| 105468 | 105468 | 101899 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 133449 | 133449 | 222768 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 79 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002832.56338 | 2108743.90779 | 37.7703689643988 | -122.433555737015 | (37.7703689643988, -122.433555737015) | |||
| 135972 | 135972 | 248088 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 14 Montcalm St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6010648.22773 | 2100325.3722900003 | 37.7476938971542 | -122.40592808351101 | (37.7476938971542, -122.405928083511) | ||||
| 137395 | 137395 | 222766 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 States St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6000813.28716 | 2106520.59939 | 37.764149535487704 | -122.440380922268 | (37.7641495354877, -122.440380922268) | |||
| 149535 | 149535 | 125945 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 100 Alice B Toklas Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006900.6119099995 | 2114145.75127 | 37.785431096899295 | -122.41986769754 | (37.7854310968993, -122.41986769754) | |||
| 150170 | 150170 | 187558 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3959 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011340.42145 | 2088314.93577 | 37.7147544402534 | -122.40268999986799 | (37.7147544402534, -122.402689999868) | ||||
| 154040 | 154040 | 248040 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 21 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010515.95575 | 2099424.13934 | 37.7452119095038 | -122.406321984771 | (37.7452119095038, -122.406321984771) | ||||
| 166055 | 166055 | 181856 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2321 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5986994.4655 | 2099435.9665 | 37.7439005468649 | -122.48765510164 | (37.7439005468649, -122.48765510164) | |||
| 187990 | 187990 | 222771 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 112 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005731.8211 | 2100248.43843 | 37.7472064655097 | -122.422923303361 | (37.7472064655097, -122.422923303361) | |||
| 29649 | 29649 | 205967 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5992062.49278 | 2100502.89931 | 37.7471243628055 | -122.470208875054 | (37.7471243628055, -122.470208875054) | |||
| 54439 | 54439 | 120440 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99 22nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5988935.73102 | 2114756.99709 | 37.7860809522857 | -122.48206489481599 | (37.7860809522857, -122.482064894816) | ||||
| 68319 | 68319 | 125942 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 330 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5996200.38714 | 2115190.8330599996 | 37.7876919907308 | -122.456962676089 | (37.7876919907308, -122.456962676089) | |||
| 70586 | 70586 | 249867 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 6011726.07393 | 2120469.26255 | 37.8030646105966 | -122.403618018374 | (37.8030646105966, -122.403618018374) | |||
| 122219 | 122219 | 125946 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 100 Alice B Toklas Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006887.306469999 | 2114142.45385 | 37.7854212934049 | -122.41991349641701 | (37.7854212934049, -122.419913496417) | |||
| 125126 | 125126 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 2398 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 125973 | 125973 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.46273356703699 | (37.748113026994, -122.462733567037) | |||||
| 144190 | 144190 | 116667 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100x Esmeralda Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 183484 | 183484 | 205962 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 338 Juanita Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5994999.304819999 | 2097584.25699 | 37.7392798481851 | -122.459842304373 | (37.7392798481851, -122.459842304373) | |||
| 29501 | 29501 | 222757 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1351 Douglass St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6001399.79942 | 2099748.33907 | 37.745587919647704 | -122.43786725507799 | (37.7455879196477, -122.437867255078) | |||
| 33207 | 33207 | 205960 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 55 Marcela Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994725.83926 | 2100688.55493 | 37.747787744113005 | -122.461012759449 | (37.747787744113, -122.461012759449) | |||
| 65456 | 65456 | 205966 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5992057.77948 | 2100503.94185 | 37.7471269528584 | -122.470225249018 | (37.7471269528584, -122.470225249018) | |||
| 69647 | 69647 | 123935 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 08th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993304.58921 | 2114931.5281 | 37.786813295089296 | -122.466962635679 | (37.7868132950893, -122.466962635679) | |||
| 95360 | 95360 | 116668 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100x Esmeralda Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 103707 | 103707 | 106342 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 497 VALLEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 6 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 158653 | 158653 | 222756 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 483 Valley St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6002764.38109 | 2099167.98488 | 37.7440719045989 | -122.43310728648501 | (37.7440719045989, -122.433107286485) | ||||
| 4439 | 4439 | 26408 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 34 Maple St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.99823 | 2116111.6508299997 | 37.7902410678174 | -122.45577816732599 | (37.7902410678174, -122.455778167326) | |||
| 73787 | 73787 | 205965 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5992042.12067 | 2100502.3853 | 37.74712177366111 | -122.47027928207899 | (37.7471217736611, -122.470279282079) | |||
| 98213 | 98213 | 20471 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1203X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 166457 | 166457 | 247914 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 399 Franconia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010000.52553 | 2098831.51714 | 37.7435558520369 | -122.40806247691499 | (37.7435558520369, -122.408062476915) | ||||
| 172422 | 172422 | 249869 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6011727.52121 | 2120455.9779 | 37.8030282150334 | -122.403612074753 | (37.8030282150334, -122.403612074753) | |||
| 188051 | 188051 | 186338 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1801 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984768.4217 | 2102859.4402 | 37.753170382716704 | -122.49560458965 | (37.7531703827167, -122.49560458965) | |||
| 6280 | 6280 | 19583 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY4 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | ||||||||
| 40395 | 40395 | 188432 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Jack Balestreri Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012439.74697 | 2104738.60671 | 37.7599117105733 | -122.400042949735 | (37.7599117105733, -122.400042949735) | ||||
| 107129 | 107129 | 20472 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1203X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 131669 | 131669 | 249870 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6011716.19315 | 2120469.03614 | 37.803063436992105 | -122.403652195296 | (37.8030634369921, -122.403652195296) | |||
| 133713 | 133713 | 186339 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1801 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984820.6505 | 2102844.4411 | 37.7531322576305 | -122.49542286858299 | (37.7531322576305, -122.495422868583) | |||
| 168545 | 168545 | 205964 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 340 Rivera St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5992030.75114 | 2100502.15338 | 37.7471204795254 | -122.470318579738 | (37.7471204795254, -122.470318579738) | |||
| 12549 | 12549 | 19584 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY4 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 |
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");