Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189070 | 189070 | 203497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.733017974899504 | -122.45086036952299 | (37.7330179748995, -122.450860369523) | |||
| 188993 | 188993 | 221754 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003935.10667 | 2102444.58543 | 37.753135026677604 | -122.42929277965099 | (37.7531350266776, -122.429292779651) | |||
| 188590 | 188590 | 189193 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012073.860090001 | 2107513.44954 | 37.767510402696296 | -122.401503402873 | (37.7675104026963, -122.401503402873) | |||
| 188318 | 188318 | 189182 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6013480.92655 | 2110921.9311900004 | 37.776947738078206 | -122.3968755078 | (37.7769477380782, -122.3968755078) | |||
| 187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) | |||
| 187777 | 187777 | 250076 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005407.46076 | 2115305.4621099997 | 37.788531142735295 | -122.425116106829 | (37.7885311427353, -122.425116106829) | |||
| 186976 | 186976 | 62043 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.240119999 | 2112760.57959 | 37.782031980627295 | -122.394782327659 | (37.7820319806273, -122.394782327659) | ||
| 186805 | 186805 | 34852 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.6555699995 | 2104887.53933 | 37.760413499914996 | -122.394284848775 | (37.760413499915, -122.394284848775) | ||
| 186745 | 186745 | 189158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008181.208740001 | 2109420.17856 | 37.7725278642987 | -122.41510258932301 | (37.7725278642987, -122.415102589323) | |||
| 186609 | 186609 | 249532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006202.66878 | 2114026.7968200003 | 37.7850651330954 | -122.42227392182801 | (37.7850651330954, -122.422273921828) | |||
| 186515 | 186515 | 189172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1947 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013391.6303 | 2095988.7563900002 | 37.735939510689605 | -122.396137605077 | (37.7359395106896, -122.396137605077) | |||
| 185700 | 185700 | 203483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.733225844180105 | -122.457954104018 | (37.7332258441801, -122.457954104018) | |||
| 185676 | 185676 | 125488 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007633.459369999 | 2115824.4780599996 | 37.7900817286446 | -122.417451271357 | (37.7900817286446, -122.417451271357) | |||
| 185557 | 185557 | 203448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991280.817840001 | 2102617.4638400003 | 37.752885184220204 | -122.473065997797 | (37.7528851842202, -122.473065997797) | |||
| 185548 | 185548 | 203447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 327 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992190.092759999 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | |||
| 185533 | 185533 | 125481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6009481.637490001 | 2116293.5320200003 | 37.791473451975605 | -122.41108984583201 | (37.7914734519756, -122.411089845832) | |||
| 185204 | 185204 | 203464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999389.85516 | 2094399.0679799998 | 37.730785591378606 | -122.44443294273701 | (37.7307855913786, -122.444432942737) | ||||
| 185192 | 185192 | 189165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | |||
| 185094 | 185094 | 52182 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.3864700003 | 37.777907863296704 | -122.410641078729 | (37.7779078632967, -122.410641078729) | |
| 185067 | 185067 | 189199 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Clementina St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011498.9088 | 2112374.96394 | 37.780826907074704 | -122.40383422349701 | (37.7808269070747, -122.403834223497) | |||
| 185062 | 185062 | 203496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998101.393730001 | 2095150.6752900002 | 37.732775726305206 | -122.448941459085 | (37.7327757263052, -122.448941459085) | |||
| 184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
| 184898 | 184898 | 221752 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003785.28495 | 2101310.15216 | 37.75001165602829 | -122.42972998686301 | (37.7500116560283, -122.429729986863) | |||
| 184886 | 184886 | 175161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000095.42068 | 2092313.2586299998 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | |||
| 184444 | 184444 | 66783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.755609999 | 2120327.60903 | 37.80235300495529 | -122.42349323614799 | (37.8023530049553, -122.423493236148) | |
| 184201 | 184201 | 220660 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003703.338380001 | 2095523.5259999998 | 37.734118272040604 | -122.429600714704 | (37.7341182720406, -122.429600714704) | |||
| 184003 | 184003 | 125521 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008568.41134 | 2119026.0619799998 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | |||
| 183969 | 183969 | 221770 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.736728574973604 | -122.436194979235 | (37.7367285749736, -122.436194979235) | |||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 183859 | 183859 | 220608 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008946.36134 | 2096525.7454799998 | 37.7371656274845 | -122.41154465636801 | (37.7371656274845, -122.411544656368) | |||
| 183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) | |||
| 183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) | ||||
| 183613 | 183613 | 175155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | |||
| 183455 | 183455 | 221765 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 165 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000037.69587 | 2106199.4106799997 | 37.7632234397255 | -122.443040392005 | (37.7632234397255, -122.443040392005) | |||
| 183131 | 183131 | 220648 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 35 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008125.23959 | 2099402.94475 | 37.74501968930829 | -122.414587200443 | (37.7450196893083, -122.414587200443) | |||
| 183063 | 183063 | 34667 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.0104900002 | 37.798287972172396 | -122.43244168475799 | (37.7982879721724, -122.432441684758) | ||
| 182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
| 182144 | 182144 | 125516 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.798928713939205 | -122.414387412476 | (37.7989287139392, -122.414387412476) | |||
| 182097 | 182097 | 249536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | |||
| 181941 | 181941 | 250077 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | |||
| 181538 | 181538 | 125480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 70 Pleasant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008592.70141 | 2116811.8420599997 | 37.7928467140568 | -122.414202246537 | (37.7928467140568, -122.414202246537) | |||
| 181526 | 181526 | 220595 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005798.00468 | 2105985.91015 | 37.762963965545296 | -122.423102194736 | (37.7629639655453, -122.423102194736) | |||
| 180841 | 180841 | 221768 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.740051458397495 | -122.426721628722 | (37.7400514583975, -122.426721628722) | |||
| 180630 | 180630 | 125526 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010063.61505 | 2116985.54141 | 37.7934061616158 | -122.40912505558799 | (37.7934061616158, -122.409125055588) | |||
| 180383 | 180383 | 220627 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002180.12335 | 2102046.5010900004 | 37.7519424707911 | -122.43533337833401 | (37.7519424707911, -122.435333378334) | |||
| 179987 | 179987 | 221769 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | |||
| 179679 | 179679 | 175156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | |||
| 179368 | 179368 | 37653 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.837669999 | 2111259.2640400003 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | |
| 178983 | 178983 | 203444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995221.104719999 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | |||
| 178911 | 178911 | 203459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993538.98145 | 2093351.56708 | 37.727573838962606 | -122.464584148065 | (37.7275738389626, -122.464584148065) | |||
| 178896 | 178896 | 220609 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | |||
| 178837 | 178837 | 92978 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009889.177999999 | 2113928.0150200003 | 37.7850011562254 | -122.409512732628 | (37.7850011562254, -122.409512732628) | ||
| 178536 | 178536 | 189195 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.767506377346294 | -122.401629018386 | (37.7675063773463, -122.401629018386) | |||
| 178396 | 178396 | 125512 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | |||
| 178320 | 178320 | 248096 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010442.96014 | 2099835.6038900004 | 37.7463376179016 | -122.406603382642 | (37.7463376179016, -122.406603382642) | |||
| 177273 | 177273 | 125532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.793138238302205 | -122.409066739034 | (37.7931382383022, -122.409066739034) | |||
| 177222 | 177222 | 125447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005068.7625400005 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | |||
| 177207 | 177207 | 175173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003787.7125 | 2091165.48018 | 37.7221568292683 | -122.428998395553 | (37.7221568292683, -122.428998395553) | |||
| 176841 | 176841 | 91499 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | |
| 176261 | 176261 | 125470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.79079101674171 | -122.40901798411501 | (37.7907910167417, -122.409017984115) | |||
| 176141 | 176141 | 189198 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 450 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010926.82993 | 2112099.93954 | 37.780039778165495 | -122.405793955035 | (37.7800397781655, -122.405793955035) | |||
| 176107 | 176107 | 220590 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002350.00188 | 2099716.4641400003 | 37.7455543857324 | -122.43457932557399 | (37.7455543857324, -122.434579325574) | |||
| 175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
| 175782 | 175782 | 33291 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37451 | 6009219.70147 | 2117007.84258 | 37.7934200822178 | -122.412046646261 | (37.7934200822178, -122.412046646261) | |
| 175671 | 175671 | 220601 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.40576983700501 | (37.7468607265348, -122.405769837005) | |||
| 175547 | 175547 | 189180 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.39907951143101 | (37.7845788525671, -122.399079511431) | |||
| 175507 | 175507 | 220607 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007434.64615 | 2096337.1519400002 | 37.7365628793641 | -122.416758001093 | (37.7365628793641, -122.416758001093) | |||
| 175422 | 175422 | 113957 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | ||
| 174841 | 174841 | 114540 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.4450199995 | 2104594.7801900003 | 37.7594980943773 | -122.40119249645299 | (37.7594980943773, -122.401192496453) | |
| 174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
| 174663 | 174663 | 125531 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010078.150640001 | 2116889.31743 | 37.793142768172395 | -122.409067968409 | (37.7931427681724, -122.409067968409) | |||
| 174293 | 174293 | 220662 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.42364628187599 | (37.7365897745051, -122.423646281876) | |||
| 174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
| 173963 | 173963 | 203499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997569.0689199995 | 2093791.20398 | 37.7290124835419 | -122.45068384968799 | (37.7290124835419, -122.450683849688) | |||
| 173556 | 173556 | 246911 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.766445417441204 | -122.451710064262 | (37.7664454174412, -122.451710064262) | |||
| 173529 | 173529 | 125459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002302.24315 | 2117372.6414900003 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | |||
| 173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
| 173406 | 173406 | 189191 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013220.726430001 | 2110673.77845 | 37.7762518804538 | -122.39775821576599 | (37.7762518804538, -122.397758215766) | |||
| 173180 | 173180 | 66747 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | |
| 173152 | 173152 | 249533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006226.92854 | 2114031.46887 | 37.78507932978 | -122.42219032262 | (37.78507932978, -122.42219032262) | |||
| 172952 | 172952 | 248094 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010447.33936 | 2099861.6956599997 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | |||
| 172712 | 172712 | 125518 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | |||
| 172584 | 172584 | 125474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009252.35721 | 2116781.07333 | 37.792799261332 | -122.411917622313 | (37.792799261332, -122.411917622313) | |||
| 172575 | 172575 | 125528 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Miller Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010067.56823 | 2116961.5742099998 | 37.7933405749546 | -122.409109685279 | (37.7933405749546, -122.409109685279) | |||
| 172296 | 172296 | 220606 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.735585147237295 | -122.41746095616999 | (37.7355851472373, -122.41746095617) | |||
| 172151 | 172151 | 220652 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | |||
| 172117 | 172117 | 125492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.42338828343901 | (37.8023660361287, -122.423388283439) | |||
| 172067 | 172067 | 125487 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007652.60673 | 2115828.9931099997 | 37.7900952031746 | -122.417385342985 | (37.7900952031746, -122.417385342985) | |||
| 172051 | 172051 | 249551 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.787680143969496 | -122.424807261672 | (37.7876801439695, -122.424807261672) | |||
| 171692 | 171692 | 189197 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.78206677001071 | -122.39473742989401 | (37.7820667700107, -122.394737429894) | |||
| 171195 | 171195 | 203445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.972519999 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | |||
| 171065 | 171065 | 125463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006804.241090001 | 2113922.09635 | 37.7848115656375 | -122.42018523378599 | (37.7848115656375, -122.420185233786) | |||
| 170748 | 170748 | 203482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.726285178816205 | -122.460793782631 | (37.7262851788162, -122.460793782631) | |||
| 170476 | 170476 | 37652 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 5 | Permit Number 40063 | 5990267.40387 | 2111259.21957 | 37.7765543890648 | -122.477202007865 | (37.7765543890648, -122.477202007865) | |
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 170184 | 170184 | 220663 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696546999 | (37.7501903863949, -122.42961696547) | |||
| 169779 | 169779 | 220610 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 243 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6009545.72231 | 2097174.03837 | 37.7389793010447 | -122.40951812496 | (37.7389793010447, -122.40951812496) | |||
| 169661 | 169661 | 220617 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999730.468230001 | 2101939.14181 | 37.7515082672912 | -122.44379689543699 | (37.7515082672912, -122.443796895437) | |||
| 169437 | 169437 | 220616 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999753.1781 | 2101988.06706 | 37.7516438994494 | -122.44372187666599 | (37.7516438994494, -122.443721876666) | |||
| 168630 | 168630 | 249544 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 298 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006142.8789800005 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) |
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");