Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, DBH, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188243 | 188243 | 180043 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000932.74205 | 2090913.3851700001 | 37.721302615409705 | -122.438849257207 | (37.7213026154097, -122.438849257207) | |||
| 187581 | 187581 | 180063 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000614.24594 | 2090358.9478799999 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | |||
| 187220 | 187220 | 29952 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 139 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 2 | 3x3 | 5995468.7175 | 2088041.2261 | 37.7131039615411 | -122.457529027577 | (37.7131039615411, -122.457529027577) | ||
| 185855 | 185855 | 180082 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000152.851 | 2089912.6147900003 | 37.7185103256827 | -122.441473335931 | (37.7185103256827, -122.441473335931) | |||
| 185585 | 185585 | 180028 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001180.14199 | 2091386.50132 | 37.7226157577852 | -122.438027939654 | (37.7226157577852, -122.438027939654) | |||
| 185409 | 185409 | 180035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001087.26718 | 2091207.92549 | 37.722120146807896 | -122.43833619936399 | (37.7221201468079, -122.438336199364) | |||
| 185396 | 185396 | 180066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000525.601009999 | 2090267.6783099999 | 37.7195064786158 | -122.440210344258 | (37.7195064786158, -122.440210344258) | |||
| 184447 | 184447 | 180037 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001052.1769900005 | 2091141.7538400001 | 37.7219364584926 | -122.438452758712 | (37.7219364584926, -122.438452758712) | |||
| 184192 | 184192 | 180315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001566.53867 | 2092362.21846 | 37.725316822989605 | -122.436762065623 | (37.7253168229896, -122.436762065623) | |||
| 183918 | 183918 | 180060 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000687.072369999 | 2090454.3849400003 | 37.7200283246365 | -122.439665576299 | (37.7200283246365, -122.439665576299) | |||
| 183605 | 183605 | 180302 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001751.00394 | 2092763.61834 | 37.726429457948896 | -122.436153099585 | (37.7264294579489, -122.436153099585) | |||
| 182417 | 182417 | 218726 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5995446.39334 | 2099958.3042 | 37.7458240951236 | -122.45846828420099 | (37.7458240951236, -122.458468284201) | |||
| 181268 | 181268 | 180072 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000400.98899 | 2090150.2778599998 | 37.719177028168296 | -122.440632664989 | (37.7191770281683, -122.440632664989) | |||
| 180203 | 180203 | 29887 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1334 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2006 12:00:00 AM | 5 | 3x3 | 6005791.53436 | 2101175.34881 | 37.7497549184585 | -122.42278268177601 | (37.7497549184585, -122.422782681776) | ||
| 180180 | 180180 | 180294 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001976.82417 | 2093214.99008 | 37.7276816496801 | -122.435404724267 | (37.7276816496801, -122.435404724267) | |||
| 179832 | 179832 | 180287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1416x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002337.82047 | 2093711.5292900002 | 37.7290655291296 | -122.434192238485 | (37.7290655291296, -122.434192238485) | |||
| 179210 | 179210 | 180051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000819.2999599995 | 2090695.20934 | 37.7206970991836 | -122.43922576376801 | (37.7206970991836, -122.439225763768) | |||
| 178643 | 178643 | 180268 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003087.38761 | 2094197.7854099998 | 37.730443193382605 | -122.43163562957399 | (37.7304431933826, -122.431635629574) | |||
| 178530 | 178530 | 180283 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1370x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6002508.03305 | 2093910.51217 | 37.7296215502929 | -122.433618015959 | (37.7296215502929, -122.433618015959) | |||
| 178016 | 178016 | 180311 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6001617.96298 | 2092474.2998799998 | 37.7256274955847 | -122.436592315896 | (37.7256274955847, -122.436592315896) | |||
| 177704 | 177704 | 180068 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000492.17507 | 2090236.21555 | 37.71941818588179 | -122.440323630039 | (37.7194181858818, -122.440323630039) | |||
| 177471 | 177471 | 180084 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000104.08716 | 2089866.26451 | 37.7183802800914 | -122.441638567472 | (37.7183802800914, -122.441638567472) | |||
| 177416 | 177416 | 180100 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5999678.44391 | 2089461.99311 | 37.7172459822806 | -122.44308081565 | (37.7172459822806, -122.44308081565) | |||
| 177174 | 177174 | 180070 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000442.5181599995 | 2090189.01132 | 37.7192857463155 | -122.440491891393 | (37.7192857463155, -122.440491891393) | |||
| 176679 | 176679 | 180039 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6001024.8340300005 | 2091089.76883 | 37.7217921640611 | -122.43854355335199 | (37.7217921640611, -122.438543553352) | |||
| 176650 | 176650 | 180059 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000706.97869 | 2090484.68802 | 37.7201126630403 | -122.439598938365 | (37.7201126630403, -122.439598938365) | |||
| 174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
| 173366 | 173366 | 180316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001554.31065 | 2092335.28136 | 37.7252421648675 | -122.43680240921499 | (37.7252421648675, -122.436802409215) | |||
| 172562 | 172562 | 180055 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000767.87775 | 2090597.6493799998 | 37.720426295310205 | -122.439396524348 | (37.7204262953102, -122.439396524348) | |||
| 171842 | 171842 | 180290 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1460x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002190.3660699995 | 2093508.3863 | 37.728499374443395 | -122.434687478938 | (37.7284993744434, -122.434687478938) | |||
| 170774 | 170774 | 180032 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001123.43555 | 2091278.0147099998 | 37.722314653084396 | -122.438216192941 | (37.7223146530844, -122.438216192941) | |||
| 168960 | 168960 | 180278 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002788.01064 | 2094092.6752799999 | 37.7301376109521 | -122.43266311221001 | (37.7301376109521, -122.43266311221) | |||
| 166549 | 166549 | 180076 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000336.55563 | 2090087.7823400002 | 37.7190017601923 | -122.440850905243 | (37.7190017601923, -122.440850905243) | |||
| 166402 | 166402 | 180027 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001199.93545 | 2091423.0449 | 37.7227172238096 | -122.43796213445299 | (37.7227172238096, -122.437962134453) | |||
| 165942 | 165942 | 180319 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1718x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001374.32809 | 2091874.1399599998 | 37.723965744512206 | -122.437391583874 | (37.7239657445122, -122.437391583874) | |||
| 165233 | 165233 | 218722 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995527.87475 | 2100010.13864 | 37.745971101902704 | -122.458190285767 | (37.7459711019027, -122.458190285767) | |||
| 165151 | 165151 | 180272 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002975.8696800005 | 2094159.7108900002 | 37.730332327675 | -122.43201844489401 | (37.730332327675, -122.432018444894) | |||
| 164433 | 164433 | 218725 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995586.52355 | 2099931.35399 | 37.745758148722 | -122.457981786952 | (37.745758148722, -122.457981786952) | |||
| 163993 | 163993 | 218620 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 350x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5993718.83551 | 2105291.49433 | 37.760368234329 | -122.46482911978501 | (37.760368234329, -122.464829119785) | |||
| 163867 | 163867 | 180022 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001269.77063 | 2091556.92369 | 37.7230887957818 | -122.43773031351101 | (37.7230887957818, -122.437730313511) | |||
| 163658 | 163658 | 180105 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999329.24691 | 2089132.49374 | 37.7163213353465 | -122.44426415617599 | (37.7163213353465, -122.444264156176) | |||
| 163020 | 163020 | 180085 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000084.46169 | 2089846.5788 | 37.7183251094034 | -122.441704992316 | (37.7183251094034, -122.441704992316) | |||
| 162595 | 162595 | 180087 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000043.80464 | 2089808.9105900002 | 37.7182193644196 | -122.44184282419201 | (37.7182193644196, -122.441842824192) | |||
| 162328 | 162328 | 218727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5995464.78871 | 2099972.9303200003 | 37.745865311950205 | -122.45840573454299 | (37.7458653119502, -122.458405734543) | |||
| 161276 | 161276 | 180025 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001228.05011 | 2091477.41325 | 37.7228681057662 | -122.437868840578 | (37.7228681057662, -122.437868840578) | |||
| 159893 | 159893 | 180095 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5999780.37585 | 2089558.42963 | 37.7175165864975 | -122.44273540673001 | (37.7175165864975, -122.44273540673) | |||
| 159126 | 159126 | 180078 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000292.29675 | 2090045.26571 | 37.7188824984081 | -122.44100084202101 | (37.7188824984081, -122.441000842021) | |||
| 158992 | 158992 | 180304 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001723.77107 | 2092703.22432 | 37.726262082416504 | -122.43624292207899 | (37.7262620824165, -122.436242922079) | |||
| 158230 | 158230 | 180067 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000510.614080001 | 2090253.83095 | 37.7194676036275 | -122.440261155949 | (37.7194676036275, -122.440261155949) | |||
| 156626 | 156626 | 97167 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 262 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6010129.00149 | 2111054.10104 | 37.7771235015924 | -122.40848022278 | (37.7771235015924, -122.40848022278) | ||||
| 155083 | 155083 | 94594 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2446 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6010864.44098 | 2086844.85353 | 37.710691304128 | -122.404231788559 | (37.710691304128, -122.404231788559) | |||
| 154867 | 154867 | 180273 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002946.6369199995 | 2094149.45197 | 37.730302501659104 | -122.432118774161 | (37.7303025016591, -122.432118774161) | |||
| 153456 | 153456 | 180101 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999657.3822800005 | 2089442.5762900002 | 37.7171914671906 | -122.44315222181999 | (37.7171914671906, -122.44315222182) | |||
| 153339 | 153339 | 180303 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001737.86404 | 2092735.16555 | 37.7263505864989 | -122.43619648829399 | (37.7263505864989, -122.436196488294) | |||
| 152359 | 152359 | 180288 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1416x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002313.88178 | 2093678.6154599998 | 37.7289737965055 | -122.434272644194 | (37.7289737965055, -122.434272644194) | |||
| 151909 | 151909 | 180045 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000902.37915 | 2090855.2234200002 | 37.7211411889036 | -122.43895004691002 | (37.7211411889036, -122.43895004691) | |||
| 151621 | 151621 | 218723 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995492.9050900005 | 2100019.87696 | 37.745995831449 | -122.458311910078 | (37.745995831449, -122.458311910078) | |||
| 149961 | 149961 | 180083 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000123.187609999 | 2089883.80862 | 37.7184295404811 | -122.441573803699 | (37.7184295404811, -122.441573803699) | |||
| 149766 | 149766 | 241883 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 387x Holly Park Cir | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6006344.8052900005 | 2096881.18885 | 37.7379953249194 | -122.420564660452 | (37.7379953249194, -122.420564660452) | |||
| 149228 | 149228 | 180065 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000553.61296 | 2090293.7338400001 | 37.7195796159879 | -122.440115384832 | (37.7195796159879, -122.440115384832) | |||
| 149096 | 149096 | 180088 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000023.47881 | 2089790.1961599998 | 37.7181668206206 | -122.441911739253 | (37.7181668206206, -122.441911739253) | |||
| 149009 | 149009 | 180053 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000792.18228 | 2090642.4993200002 | 37.720550826234295 | -122.439315724734 | (37.7205508262343, -122.439315724734) | |||
| 147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
| 147733 | 147733 | 180021 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001282.227940001 | 2091580.1925 | 37.7231533949913 | -122.437688916822 | (37.7231533949913, -122.437688916822) | |||
| 146279 | 146279 | 89488 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4240X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985419.65784 | 2111821.23422 | 37.7778150691874 | -122.49401294624201 | (37.7778150691874, -122.494012946242) | ||
| 145883 | 145883 | 271 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 145731 | 145731 | 25249 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Ocean Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | 6 | 3x3 | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |
| 145658 | 145658 | 29005 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 07:53:00 AM | 3 | 3x3 | 6008208.2208875 | 2110209.5743772998 | 37.7746968767058 | -122.41506503651001 | (37.7746968767058, -122.41506503651) | ||
| 145600 | 145600 | 27151 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1725 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2013 12:00:00 AM | 3 | 3X3 | 6011106.67473 | 2095144.47702 | 37.733493897217606 | -122.40397825412701 | (37.7334938972176, -122.403978254127) | ||
| 145176 | 145176 | 15678 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3976 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1995 12:00:00 AM | 6 | 3X3 | 6004719.66421 | 2095527.6567 | 37.734187108285106 | -122.426087249435 | (37.7341871082851, -122.426087249435) | ||
| 144932 | 144932 | 86508 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1304 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987730.517605 | 2106398.207322 | 37.763059886107605 | -122.485620887193 | (37.7630598861076, -122.485620887193) | ||
| 144719 | 144719 | 89483 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4140X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985736.95806 | 2111833.5334 | 37.7778673998673 | -122.492916216472 | (37.7778673998673, -122.492916216472) | ||
| 144705 | 144705 | 89505 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4550X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984502.23561 | 2111789.09375 | 37.7776730981355 | -122.49718420673 | (37.7776730981355, -122.49718420673) | ||
| 144664 | 144664 | 449 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988819.75093 | 2110337.06115 | 37.7739383014913 | -122.482142223603 | (37.7739383014913, -122.482142223603) | |||
| 144552 | 144552 | 112241 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2015 07:34:00 AM | 3 | 5999054.92129 | 2088906.8460099997 | 37.715686103277505 | -122.44519614164 | (37.7156861032775, -122.44519614164) | |||
| 144467 | 144467 | 19536 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000638.9566999 | 2112754.3859284 | 37.781256017340496 | -122.441431224449 | (37.7812560173405, -122.441431224449) | |||
| 144150 | 144150 | 85969 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2490X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987696.060132 | 2098350.294875 | 37.7409604754519 | -122.485149538477 | (37.7409604754519, -122.485149538477) | ||
| 144102 | 144102 | 109712 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2016 08:12:00 AM | 3 | 3x3 | 6007405.7 | 2097308.5 | 37.7392283588276 | -122.41692688061899 | (37.7392283588276, -122.416926880619) | ||
| 144000 | 144000 | 335 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:03:00 PM | 3 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 143902 | 143902 | 90314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2235 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988592.870069999 | 2111199.48837 | 37.776293087727296 | -122.48299025479099 | (37.7762930877273, -122.482990254791) | ||
| 143875 | 143875 | 86083 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2390X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987672.668172 | 2099031.041747 | 37.742828263888796 | -122.48528035718701 | (37.7428282638888, -122.485280357187) | ||
| 143874 | 143874 | 7839 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 825X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2015 12:00:00 AM | 3 | 4X4 | 6006486.55974 | 2113185.80052 | 37.782771972590204 | -122.421232006807 | (37.7827719725902, -122.421232006807) | ||
| 143750 | 143750 | 9252 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6500X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 3 | 3X3 | 5986738.4494 | 2112596.6534599997 | 37.7800212263112 | -122.48950788341001 | (37.7800212263112, -122.48950788341) | ||
| 143112 | 143112 | 24692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7033 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2002 12:00:00 AM | 3 | 3X3 | 5985144.33925 | 2112442.01749 | 37.7795034482738 | -122.495011140729 | (37.7795034482738, -122.495011140729) | ||
| 143092 | 143092 | 12027 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/1996 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
| 143082 | 143082 | 11983 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 143039 | 143039 | 115184 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 142950 | 142950 | 89521 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4820 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983664.064230001 | 2111757.54508 | 37.7775373182225 | -122.50008134805701 | (37.7775373182225, -122.500081348057) | ||
| 142860 | 142860 | 90316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2201 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988678.50027 | 2111201.68206 | 37.7763040932889 | -122.482694200607 | (37.7763040932889, -122.482694200607) | ||
| 142746 | 142746 | 98056 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5285 Diamond Heights Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | ||
| 142710 | 142710 | 89597 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4425 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984898.50732 | 2111748.34415 | 37.777584426869204 | -122.495810381718 | (37.7775844268692, -122.495810381718) | ||
| 142671 | 142671 | 15674 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3960X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1995 12:00:00 AM | 6 | 3X3 | 6004806.3206 | 2095614.6010599998 | 37.7344307353685 | -122.42579383714701 | (37.7344307353685, -122.425793837147) | ||
| 142657 | 142657 | 14520 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 608 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999209.18442 | 2110749.22895 | 37.7756688162726 | -122.446233231658 | (37.7756688162726, -122.446233231658) | |||
| 142528 | 142528 | 4542 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 66 Cleary Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 10:23:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 142416 | 142416 | 90420 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 170 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6005607.619214 | 2108489.805018 | 37.769828319331104 | -122.423938734655 | (37.7698283193311, -122.423938734655) | ||
| 142393 | 142393 | 19508 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000691.8143212 | 2112375.2561029 | 37.780218034815704 | -122.44122115340001 | (37.7802180348157, -122.4412211534) | |||
| 142325 | 142325 | 24788 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7795X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5982848.853180001 | 2112367.91788 | 37.779165345195295 | -122.502946585831 | (37.7791653451953, -122.502946585831) | |||
| 142272 | 142272 | 26353 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700X San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 5 | 3x3 | 5997086.2921907995 | 2088490.3931717 | 37.7144300543779 | -122.451970559571 | (37.7144300543779, -122.451970559571) | ||
| 141987 | 141987 | 90397 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006087.6120339995 | 2109147.850555 | 37.7716622416587 | -122.42232521004999 | (37.7716622416587, -122.42232521005) | ||
| 141698 | 141698 | 90419 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 156 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6005694.92174 | 2108494.602985 | 37.76984642174521 | -122.423637098191 | (37.7698464217452, -122.423637098191) |
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");