Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 3162 | 3162 | 11135 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007038.94291 | 2120769.9344599997 | 37.8036272444521 | -122.41985932665199 | (37.8036272444521, -122.419859326652) | |||
| 3427 | 3427 | 11134 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.41985060413299 | (37.8035840176492, -122.419850604133) | |||
| 7429 | 7429 | 11136 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007037.38216 | 2120783.1998 | 37.803663579779204 | -122.41986566958299 | (37.8036635797792, -122.419865669583) | |||
| 28417 | 28417 | 4380 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007006.012916099 | 2120659.6131485 | 37.8033224749672 | -122.41996544931101 | (37.8033224749672, -122.419965449311) | |||
| 101172 | 101172 | 7707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 117312 | 117312 | 7709 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 118702 | 118702 | 11141 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 118720 | 118720 | 4381 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2421X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007006.012916099 | 2120659.6131485 | 37.8033224749672 | -122.41996544931101 | (37.8033224749672, -122.419965449311) | |||
| 122047 | 122047 | 11138 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 128882 | 128882 | 7706 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 7265 | 7265 | 11178 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.806291497706106 | -122.42056067914899 | (37.8062914977061, -122.420560679149) | |||
| 88395 | 88395 | 1425 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995464.3721900005 | 2115634.54937 | 37.7888680229269 | -122.45954127761101 | (37.7888680229269, -122.459541277611) | |||
| 93508 | 93508 | 1418 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995436.85306 | 2115829.92253 | 37.7894028822964 | -122.459650645871 | (37.7894028822964, -122.459650645871) | |||
| 101063 | 101063 | 11148 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 128539 | 128539 | 11146 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 144995 | 144995 | 1427 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995465.80895 | 2115602.75583 | 37.7887808090871 | -122.45953400306699 | (37.7887808090871, -122.459534003067) | |||
| 38615 | 38615 | 177876 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4117 San Bruno Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.40219173226299 | (37.7124588649577, -122.402191732263) | |||
| 75041 | 75041 | 194131 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1310 Indiana St | 4 | : Yard 23 | Tree 1 | Private 1 | 37 | 6014985.85621 | 2102536.5970099997 | 37.754007092062004 | -122.391083210127 | (37.754007092062, -122.391083210127) | ||||
| 1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 5888 | 5888 | 11169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | |||
| 6289 | 6289 | 11171 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.805969514352604 | -122.420334179488 | (37.8059695143526, -122.420334179488) | |||
| 8792 | 8792 | 11170 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | |||
| 18147 | 18147 | 56051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.768410964941104 | -122.43229368198 | (37.7684109649411, -122.43229368198) | ||
| 97969 | 97969 | 11184 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | |||
| 99823 | 99823 | 11150 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 103862 | 103862 | 11145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 113524 | 113524 | 11152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 120483 | 120483 | 11149 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 126649 | 126649 | 11174 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | |||
| 138383 | 138383 | 11151 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 112417 | 112417 | 56992 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4180 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 32 | 3x3 | Permit Number 14247 | 6002733.4 | 2100680.6 | 37.748223434052896 | -122.433322476919 | (37.7482234340529, -122.433322476919) | |
| 135118 | 135118 | 131783 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2662 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6000251.4406 | 2118197.96121 | 37.796180572834395 | -122.443162912062 | (37.7961805728344, -122.443162912062) | |||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 6990 | 6990 | 11166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006897.54428 | 2121449.5194099997 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | |||
| 7672 | 7672 | 11164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424728999 | (37.8055622446775, -122.42024424729) | |||
| 8511 | 8511 | 11154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006919.78752 | 2121256.3248099997 | 37.804956035058495 | -122.420306213261 | (37.8049560350585, -122.420306213261) | |||
| 9132 | 9132 | 11160 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | |||
| 52876 | 52876 | 210610 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1265 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 5994218.26536 | 2106902.4695099997 | 37.7648203353176 | -122.463218734373 | (37.7648203353176, -122.463218734373) | |||
| 93233 | 93233 | 1426 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5PL | 5995463.35217 | 2115623.5326099996 | 37.788837715235296 | -122.459544008497 | (37.7888377152353, -122.459544008497) | |||
| 103231 | 103231 | 11161 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006954.2638733005 | 2121382.2190943 | 37.805303651298296 | -122.420195844212 | (37.8053036512983, -122.420195844212) | |||
| 103367 | 103367 | 1424 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5PL | 5995463.97403 | 2115644.21361 | 37.788894535419004 | -122.459543355401 | (37.788894535419, -122.459543355401) | |||
| 121329 | 121329 | 11140 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 126572 | 126572 | 1419 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5X5PL | 5995462.58605 | 2115703.1082900004 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | |||
| 145542 | 145542 | 1417 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 5995446.00012 | 2115789.3040299998 | 37.7892918808868 | -122.459616055153 | (37.7892918808868, -122.459616055153) | |||
| 176763 | 176763 | 131835 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999258.4917 | 2116863.93405 | 37.7924610209078 | -122.446502680257 | (37.7924610209078, -122.446502680257) | ||||
| 180974 | 180974 | 194218 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1121 Jamestown Ave | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 6013410.02884 | 2090031.5953 | 37.7195833814573 | -122.39565673576901 | (37.7195833814573, -122.395656735769) | ||||
| 135205 | 135205 | 177925 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5989826.52584 | 2090074.03315 | 37.71835983492971 | -122.477178590321 | (37.7183598349297, -122.477178590321) | ||||
| 161579 | 161579 | 233771 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003168.16978 | 2108097.17278 | 37.768612224197895 | -122.43234867777299 | (37.7686122241979, -122.432348677773) | |||
| 26009 | 26009 | 233688 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3922 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6003611.35002 | 2102468.43806 | 37.753182186212705 | -122.430414095727 | (37.7531821862127, -122.430414095727) | |||
| 131484 | 131484 | 132028 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 33x Battery St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.39944731163901 | (37.7911327033699, -122.399447311639) | ||||
| 136889 | 136889 | 194217 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1121 Jamestown Ave | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6013395.77535 | 2090042.77857 | 37.719613295602606 | -122.39570678843398 | (37.7196132956026, -122.395706788434) | ||||
| 161069 | 161069 | 233720 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 363 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6001159.54582 | 2104278.3717799997 | 37.75801263648471 | -122.439022610525 | (37.7580126364847, -122.439022610525) | |||
| 148465 | 148465 | 210778 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1326 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 5994894.46082 | 2106511.1669799997 | 37.763784851410705 | -122.460851603619 | (37.7637848514107, -122.460851603619) | |||
| 166980 | 166980 | 131838 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5999266.73194 | 2116784.7686099997 | 37.7922441242069 | -122.446468470962 | (37.7922441242069, -122.446468470962) | ||||
| 18831 | 18831 | 4449 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004544.3142800005 | 2100922.31022 | 37.748989683529 | -122.427077601077 | (37.748989683529, -122.427077601077) | |||
| 29305 | 29305 | 233199 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 275 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6008258.10546 | 2097284.7360400003 | 37.739211019461706 | -122.41397795473499 | (37.7392110194617, -122.413977954735) | |||
| 53000 | 53000 | 131837 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 5999265.5562 | 2116805.62915 | 37.792301334578795 | -122.446474040467 | (37.7923013345788, -122.446474040467) | ||||
| 68441 | 68441 | 131840 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3100 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 10ft | 5999063.8869199995 | 2119477.76228 | 37.79962677850121 | -122.447364232598 | (37.7996267785012, -122.447364232598) | |||
| 136943 | 136943 | 233675 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 283 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6003330.4753 | 2101529.9241299997 | 37.7505893337346 | -122.43131842791901 | (37.7505893337346, -122.431318427919) | |||
| 153910 | 153910 | 210611 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1293 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5994219.67009 | 2106748.1448 | 37.76439668089 | -122.46320267698201 | (37.76439668089, -122.463202676982) | |||
| 179303 | 179303 | 131836 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 5999261.40107 | 2116837.9999700002 | 37.792389978960294 | -122.446490747163 | (37.7923899789603, -122.446490747163) | ||||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 6828 | 6828 | 11159 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | |||
| 20963 | 20963 | 10267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | 6004928.575180001 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | |||
| 30028 | 30028 | 233796 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 35 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6004294.34985 | 2098061.60809 | 37.741120716350004 | -122.427738180998 | (37.74112071635, -122.427738180998) | |||
| 56677 | 56677 | 131833 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999254.62224 | 2116910.03669 | 37.7925873855434 | -122.44651938697399 | (37.7925873855434, -122.446519386974) | ||||
| 78218 | 78218 | 2006 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 82107 | 82107 | 57242 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 89 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 24 | 5x5 | Permit Number 14530 | 6003195.89085899 | 2107782.79222796 | 37.7677505837132 | -122.43223033805201 | (37.7677505837132, -122.432230338052) | |
| 98696 | 98696 | 11137 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 102353 | 102353 | 23412 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1800 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6006192.04644 | 2116736.2511 | 37.792504023132 | -122.422503264879 | (37.792504023132, -122.422503264879) | |||
| 117493 | 117493 | 23938 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2200 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003391.086760299 | 2115232.9501378 | 37.7882179316444 | -122.43208726624201 | (37.7882179316444, -122.432087266242) | |||
| 174406 | 174406 | 131834 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999256.96111 | 2116889.83912 | 37.79253206195229 | -122.446509840679 | (37.7925320619523, -122.446509840679) | ||||
| 38114 | 38114 | 210613 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1286 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5994265.07263 | 2106754.70489 | 37.7644173086225 | -122.463046119387 | (37.7644173086225, -122.463046119387) | |||
| 49307 | 49307 | 210742 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1231 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 5995454.06251 | 2107177.64382 | 37.7656470074244 | -122.458964384416 | (37.7656470074244, -122.458964384416) | |||
| 54487 | 54487 | 233765 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003185.97234 | 2107800.9752700003 | 37.7677999475382 | -122.432265943725 | (37.7677999475382, -122.432265943725) | |||
| 59742 | 59742 | 233705 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 77 Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6003150.20355 | 2105613.21116 | 37.7617908493849 | -122.43223340265101 | (37.7617908493849, -122.432233402651) | |||
| 62381 | 62381 | 248225 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 71 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6007150.64932 | 2099361.50355 | 37.744851098794996 | -122.417954229804 | (37.744851098795, -122.417954229804) | ||||
| 69761 | 69761 | 117845 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.49954924088199 | (37.7768809995382, -122.499549240882) | |||
| 158733 | 158733 | 233704 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 77 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6003137.31519 | 2105615.26563 | 37.761795759696 | -122.43227812504801 | (37.761795759696, -122.432278125048) | |||
| 949 | 949 | 13070 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.803032589908106 | -122.4119030734 | (37.8030325899081, -122.4119030734) | |||
| 39000 | 39000 | 131839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5999268.60171 | 2116764.1225799997 | 37.7921875424622 | -122.44646051556002 | (37.7921875424622, -122.44646051556) | ||||
| 48067 | 48067 | 233128 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4180 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002725.3239 | 2100663.7582400003 | 37.7481767323696 | -122.433349200502 | (37.7481767323696, -122.433349200502) | |||
| 48644 | 48644 | 124648 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 5ft | 5995458.44608 | 2115807.32553 | 37.7893420787061 | -122.459574299668 | (37.7893420787061, -122.459574299668) | |||
| 186360 | 186360 | 233770 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 47 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6003173.70397 | 2108040.8462 | 37.768457878964 | -122.43232551211399 | (37.768457878964, -122.432325512114) | |||
| 31072 | 31072 | 177863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 916 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6000908.69865 | 2091687.2057 | 37.723425983093 | -122.43898779685101 | (37.723425983093, -122.438987796851) | |||
| 45222 | 45222 | 210624 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1306 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5993034.36809 | 2106545.7737 | 37.763772669194005 | -122.467287556882 | (37.763772669194, -122.467287556882) | |||
| 73130 | 73130 | 131832 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5999253.705019999 | 2116932.2658599997 | 37.7926483685714 | -122.446524160568 | (37.7926483685714, -122.446524160568) | ||||
| 131401 | 131401 | 210585 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1677 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5991143.28102 | 2103974.0449900003 | 37.756602035466706 | -122.47364057105499 | (37.7566020354667, -122.473640571055) | |||
| 159818 | 159818 | 131875 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1445 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002295.777919999 | 2121559.23288 | 37.8055260973233 | -122.43632978131001 | (37.8055260973233, -122.43632978131) | |||
| 159991 | 159991 | 210774 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1280 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993026.35283 | 2106694.6315099997 | 37.764180930828 | -122.467326103619 | (37.764180930828, -122.467326103619) | |||
| 15055 | 15055 | 113527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408001 | (37.7659290977746, -122.39792893408) | ||||
| 24398 | 24398 | 178021 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 501 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6009115.97426 | 2093800.21325 | 37.729691414114704 | -122.41076579579901 | (37.7296914141147, -122.410765795799) | |||
| 81797 | 81797 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 811 TREAT AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 3x3 | 6008597.0 | 2103712.0 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | |||
| 83367 | 83367 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 20 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | |||
| 97034 | 97034 | 12612 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 737 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1999 12:00:00 AM | 20 | 4X4 | 5993226.095 | 2114817.124 | 37.7864946419858 | -122.46722588360201 | (37.7864946419858, -122.467225883602) | ||
| 109370 | 109370 | 1414 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | |||
| 118641 | 118641 | 1413 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X5 | 5995443.6836 | 2115866.47874 | 37.7895036485155 | -122.459629661947 | (37.7895036485155, -122.459629661947) |
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");