Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
151865 | 151865 | 221485 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.762511869155105 | -122.42389003321101 | (37.7625118691551, -122.423890033211) | |||
55100 | 55100 | 221486 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | |||
52085 | 52085 | 221487 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005570.243559999 | 2105766.57088 | 37.762348856238205 | -122.42387434542101 | (37.7623488562382, -122.423874345421) | |||
38301 | 38301 | 221488 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732621999 | (37.7622746387822, -122.42386732622) | |||
51561 | 51561 | 221489 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005574.236269999 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | |||
66900 | 66900 | 221490 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | |||
179323 | 179323 | 221491 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005578.642000001 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | |||
80086 | 80086 | 37574 | Permitted Site 1 | Acacia stenophylla :: Shoestring Acacia 109 | 30 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/2014 12:00:00 AM | 3 | Permit Number 773155 | 6001973.00287599 | 2105680.02476784 | 37.7619074866084 | -122.43630964556101 | (37.7619074866084, -122.436309645561) | |
47104 | 47104 | 221492 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005579.45797 | 2105601.3239599997 | 37.761895647375205 | -122.42383072560301 | (37.7618956473752, -122.423830725603) | |||
159086 | 159086 | 221493 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.42381549380801 | (37.7617917972666, -122.423815493808) | |||
4507 | 4507 | 221494 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:53:00 PM | 2 | Width 3ft | 6005589.49697 | 2105398.2938599996 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | ||
88573 | 88573 | 109696 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
91073 | 91073 | 109698 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:01:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
92681 | 92681 | 109700 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:08:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
95444 | 95444 | 109697 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
106423 | 106423 | 109703 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:05:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
107320 | 107320 | 109701 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
110419 | 110419 | 109704 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
118317 | 118317 | 109694 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:54:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
123889 | 123889 | 109693 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:53:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
126273 | 126273 | 109695 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
142527 | 142527 | 109699 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
144040 | 144040 | 109702 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
4454 | 4454 | 221495 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:54:00 PM | 2 | Width 3ft | 6005593.17627 | 2105367.35468 | 37.761253997298205 | -122.42376664264299 | (37.7612539972982, -122.423766642643) | ||
4523 | 4523 | 221496 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 2 | Width 3ft | 6005594.03058 | 2105332.56679 | 37.761158526170895 | -122.423761214331 | (37.7611585261709, -122.423761214331) | ||
4491 | 4491 | 221497 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.4476799998 | 37.761056664463204 | -122.42375498292499 | (37.7610566644632, -122.423754982925) | ||
184414 | 184414 | 221498 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | |||
4499 | 4499 | 221499 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.090469999 | 2105206.48742 | 37.760812740428904 | -122.42372783238899 | (37.7608127404289, -122.423727832389) | ||
4478 | 4478 | 221500 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.2083400004 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | ||
4526 | 4526 | 221501 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:08:00 PM | 2 | Width 3ft | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | ||
4481 | 4481 | 221502 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.760470912626296 | -122.42369608451 | (37.7604709126263, -122.42369608451) | ||
4517 | 4517 | 221503 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | ||
4487 | 4487 | 221504 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.42367708812901 | (37.7602778227802, -122.423677088129) | ||
48680 | 48680 | 221505 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.760179131174795 | -122.423662162075 | (37.7601791311748, -122.423662162075) | |||
136012 | 136012 | 187785 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1740 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.39891512883499 | (37.7599511143744, -122.398915128835) | |||
5138 | 5138 | 152412 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | |||
5110 | 5110 | 152413 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005625.074080001 | 2104777.98262 | 37.7596375207611 | -122.42361441706899 | (37.7596375207611, -122.423614417069) | |||
5114 | 5114 | 152414 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | |||
5137 | 5137 | 152415 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | |||
86391 | 86391 | 184203 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.75941282066329 | -122.500400782356 | (37.7594128206633, -122.500400782356) | |||
5111 | 5111 | 152416 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005631.99539 | 2104658.5890900004 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | |||
5135 | 5135 | 152417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | |||
5131 | 5131 | 152418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005636.4507 | 2104585.0792400003 | 37.759108495478394 | -122.42356135618999 | (37.7591084954784, -122.42356135619) | |||
5122 | 5122 | 152419 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005637.900330001 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | |||
5118 | 5118 | 152420 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005641.8915099995 | 2104501.69931 | 37.7588798608311 | -122.42353661133998 | (37.7588798608311, -122.42353661134) | |||
51201 | 51201 | 221569 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | |||
5113 | 5113 | 152421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | |||
5168 | 5168 | 152422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005644.9376300005 | 2104427.7274700003 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | |||
5127 | 5127 | 152423 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.758591964470895 | -122.423518008854 | (37.7585919644709, -122.423518008854) | |||
87711 | 87711 | 91236 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 804 Guerrero St | 1 | Median : 22 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614.0 | 2104300.0 | 37.758324467407704 | -122.423618732861 | (37.7583244674077, -122.423618732861) | ||
141675 | 141675 | 91237 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 808 Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 4x15 | 6005611.0 | 2104262.0 | 37.7582199589604 | -122.423626406477 | (37.7582199589604, -122.423626406477) | ||
117919 | 117919 | 91293 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 812x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2001 12:00:00 AM | 3 | 6005612.0 | 2104238.0 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | |||
123181 | 123181 | 91238 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 812x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005612.0 | 2104238.0 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | |||
134894 | 134894 | 221423 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005658.05131 | 2104209.2390900003 | 37.7580777456208 | -122.42345993152901 | (37.7580777456208, -122.423459931529) | |||
174460 | 174460 | 221422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103001 | (37.7579289437835, -122.42344282103) | |||
155282 | 155282 | 221421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005663.971419999 | 2104121.3615 | 37.7578367884406 | -122.42343320997499 | (37.7578367884406, -122.423433209975) | |||
147617 | 147617 | 221420 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005663.71373 | 2104068.90036 | 37.7576927278639 | -122.423430371709 | (37.7576927278639, -122.423430371709) | |||
79149 | 79149 | 91241 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
82614 | 82614 | 91242 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
94067 | 94067 | 91239 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 1 | Median : Hanging Pot 28 | Tree 1 | DPW 2 | 11/20/1989 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
145184 | 145184 | 91240 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
109310 | 109310 | 91243 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 850x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/10/2009 12:00:00 AM | 3 | 6005625.0 | 2104018.0 | 37.7575507822519 | -122.423560641088 | (37.7575507822519, -122.423560641088) | |||
55774 | 55774 | 221419 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005664.4202 | 2104015.7148700003 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | |||
49955 | 49955 | 91244 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 852x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:21:00 AM | 3 | 6005625.0 | 2104006.0 | 37.757517833055395 | -122.423559787953 | (37.7575178330554, -122.423559787953) | |||
44886 | 44886 | 221418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353200996 | -122.423415847665 | (37.757466353201, -122.423415847665) | |||
79479 | 79479 | 91245 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 870x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005631.0 | 2103898.0 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | |||
88269 | 88269 | 91249 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 870x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:26:00 AM | 3 | 6005631.0 | 2103898.0 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | |||
159637 | 159637 | 221417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.42338472483101 | (37.7571924071266, -122.423384724831) | |||
101453 | 101453 | 91246 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 876x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005633.0 | 2103862.0 | 37.7571228942355 | -122.423521883288 | (37.7571228942355, -122.423521883288) | |||
30827 | 30827 | 221416 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005677.18728 | 2103848.76992 | 37.757089061516204 | -122.42336812603399 | (37.7570890615162, -122.423368126034) | |||
90343 | 90343 | 91247 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 880x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:29:00 AM | 3 | 6005634.0 | 2103838.0 | 37.7570570522806 | -122.423516718678 | (37.7570570522806, -122.423516718678) | |||
43283 | 43283 | 221415 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005678.5014 | 2103825.14435 | 37.7570242653802 | -122.42336190183201 | (37.7570242653802, -122.423361901832) | |||
83208 | 83208 | 91248 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 888x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | |||
41267 | 41267 | 221568 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | |||
141128 | 141128 | 91251 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 906X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.14042 | 2103682.124768 | 37.756631377266295 | -122.42336335858299 | (37.7566313772663, -122.423363358583) | ||
111602 | 111602 | 91252 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 908x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.42336040770901 | (37.7566004799608, -122.423360407709) | ||
189094 | 189094 | 221424 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.534530001 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | |||
134735 | 134735 | 221425 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.42330702161301 | (37.7563992716189, -122.423307021613) | |||
128795 | 128795 | 91254 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 928x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.9790819995 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | ||
46284 | 46284 | 221426 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005693.61577 | 2103548.6076700003 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | |||
32169 | 32169 | 221427 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.42327543382099 | (37.7561368116793, -122.423275433821) | |||
108090 | 108090 | 91255 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | ||
118503 | 118503 | 91256 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | ||
35380 | 35380 | 221506 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.756066894799204 | -122.423269241105 | (37.7560668947992, -122.423269241105) | |||
148070 | 148070 | 221507 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005699.48542 | 2103446.5929900003 | 37.755986035831704 | -122.42326242243999 | (37.7559860358317, -122.42326242244) | |||
101466 | 101466 | 91258 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 948x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047001 | 2103445.549621 | 37.755982533848794 | -122.423301390711 | (37.7559825338488, -122.423301390711) | ||
78847 | 78847 | 91259 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 952x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | ||
155244 | 155244 | 221567 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | |||
168829 | 168829 | 221544 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005705.623380001 | 2103333.32509 | 37.755675374928295 | -122.423233144119 | (37.7556753749283, -122.423233144119) | |||
111728 | 111728 | 91263 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 970x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.42326893177601 | (37.7556426634019, -122.423268931776) | ||
61658 | 61658 | 221543 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640818999 | (37.7556029507207, -122.42322640819) | |||
149575 | 149575 | 221542 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005709.18006 | 2103278.9471400003 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | |||
80089 | 80089 | 91264 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 978X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.5214949995 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | ||
178961 | 178961 | 221541 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | |||
111105 | 111105 | 91265 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 986x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | ||
18919 | 18919 | 110775 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:57:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
80233 | 80233 | 110778 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
80584 | 80584 | 110774 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
82047 | 82047 | 110777 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:47:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
93547 | 93547 | 110779 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:35:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) |
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");