trees
339 rows where qSpecies_id = 30 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116925 | 221485 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.7625118691551 | -122.423890033211 | (37.7625118691551, -122.423890033211) | 8 | 4 | 5 | 28859 | 19 | |||
| 15879 | 221486 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | 8 | 4 | 5 | 28859 | 19 | ||
| 73812 | 221487 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005570.24356 | 2105766.57088 | 37.7623488562382 | -122.423874345421 | (37.7623488562382, -122.423874345421) | 8 | 4 | 5 | 28859 | 19 | |||
| 6358 | 208585 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1424 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784722 | 5993062.7204 | 2105752.14993 | 37.7615952234535 | -122.467131790705 | (37.7615952234535, -122.467131790705) | 1 | 8 | 4 | 56 | 12 | |
| 31806 | 221488 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732622 | (37.7622746387822, -122.42386732622) | 8 | 4 | 5 | 28859 | 19 | |||
| 76054 | 221489 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005574.23627 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | 8 | 4 | 5 | 28859 | 19 | |||
| 49439 | 37574 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 30 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/2014 12:00:00 AM | 3 | Permit Number 773155 | 6001973.00287599 | 2105680.02476784 | 37.7619074866084 | -122.436309645561 | (37.7619074866084, -122.436309645561) | 15 | 4 | 5 | 28862 | 3 | |
| 85812 | 221490 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | 8 | 4 | 5 | 28859 | 19 | |||
| 177960 | 221491 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005578.642 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | 8 | 4 | 5 | 28859 | 19 | |||
| 45759 | 221492 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005579.45797 | 2105601.32396 | 37.7618956473752 | -122.423830725603 | (37.7618956473752, -122.423830725603) | 8 | 4 | 5 | 28859 | 19 | |||
| 143760 | 221493 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.423815493808 | (37.7617917972666, -122.423815493808) | 8 | 4 | 5 | 28859 | 19 | |||
| 813 | 221494 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 2 | 3x3 | Permit Number 56125 | 6005589.49697 | 2105398.29386 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | 2 | 4 | 5 | 28859 | 19 | |
| 19567 | 109693 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 26192 | 109695 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 59561 | 109696 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 76998 | 109698 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 89953 | 109700 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 95085 | 109697 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 122027 | 109703 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 129565 | 109701 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 133232 | 109704 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 152652 | 109694 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 171275 | 109699 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 187231 | 109702 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 3217 | 221495 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 2 | 3x3 | Permit Number 56125 | 6005593.17627 | 2105367.35468 | 37.7612539972982 | -122.423766642643 | (37.7612539972982, -122.423766642643) | 2 | 4 | 5 | 28859 | 19 | |
| 1562 | 221496 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 2 | 3x3 | Permit Number 56125 | 6005594.03058 | 2105332.56679 | 37.7611585261709 | -122.423761214331 | (37.7611585261709, -122.423761214331) | 2 | 4 | 5 | 28859 | 19 | |
| 98803 | 221497 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.44768 | 37.7610566644632 | -122.423754982925 | (37.7610566644632, -122.423754982925) | 2 | 4 | 5 | 28859 | 19 | ||
| 181202 | 221498 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | 2 | 4 | 5 | 28859 | 19 | |||
| 96256 | 221499 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.09047 | 2105206.48742 | 37.7608127404289 | -122.423727832389 | (37.7608127404289, -122.423727832389) | 2 | 4 | 5 | 28859 | 19 | ||
| 60014 | 221500 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.20834 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | 2 | 4 | 5 | 28859 | 19 | ||
| 190176 | 184203 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.7594128206633 | -122.500400782356 | (37.7594128206633, -122.500400782356) | 1 | 8 | 3 | 56 | 35 | |||
| 7635 | 221501 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 2 | 3x3 | Permit Number 56125 | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | 2 | 4 | 5 | 28859 | 19 | |
| 62629 | 221502 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.7604709126263 | -122.42369608451 | (37.7604709126263, -122.42369608451) | 2 | 4 | 5 | 28859 | 19 | ||
| 160656 | 221503 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | 2 | 4 | 5 | 28859 | 19 | ||
| 66526 | 221504 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.423677088129 | (37.7602778227802, -122.423677088129) | 2 | 4 | 5 | 28859 | 19 | ||
| 54220 | 221505 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.7601791311748 | -122.423662162075 | (37.7601791311748, -122.423662162075) | 2 | 4 | 5 | 28859 | 19 | |||
| 106244 | 152412 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | 2 | 4 | 5 | 28859 | 19 | |||
| 13699 | 152413 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005625.07408 | 2104777.98262 | 37.7596375207611 | -122.423614417069 | (37.7596375207611, -122.423614417069) | 2 | 4 | 5 | 28859 | 19 | |||
| 57039 | 152414 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | 2 | 4 | 5 | 28859 | 19 | |||
| 22553 | 187785 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1740 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.398915128835 | (37.7599511143744, -122.398915128835) | 10 | 3 | 8 | 28856 | 29 | |||
| 96333 | 152415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | 2 | 4 | 5 | 28859 | 19 | |||
| 12356 | 152416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005631.99539 | 2104658.58909 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | 2 | 4 | 5 | 28859 | 19 | |||
| 107424 | 152417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | 2 | 4 | 5 | 28859 | 19 | |||
| 84453 | 152418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005636.4507 | 2104585.07924 | 37.7591084954784 | -122.42356135619 | (37.7591084954784, -122.42356135619) | 2 | 4 | 5 | 28859 | 19 | |||
| 58618 | 152419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005637.90033 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | 2 | 4 | 5 | 28859 | 19 | |||
| 83337 | 221569 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | 2 | 4 | 5 | 28862 | 3 | |||
| 52094 | 152420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005641.89151 | 2104501.69931 | 37.7588798608311 | -122.42353661134 | (37.7588798608311, -122.42353661134) | 2 | 4 | 5 | 28859 | 19 | |||
| 46202 | 152421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | 2 | 4 | 5 | 28859 | 19 | |||
| 190784 | 152422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005644.93763 | 2104427.72747 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | 2 | 4 | 5 | 28859 | 19 | |||
| 61134 | 152423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.7585919644709 | -122.423518008854 | (37.7585919644709, -122.423518008854) | 2 | 4 | 5 | 28859 | 19 | |||
| 67854 | 91236 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 804 Guerrero St | 1 | Median : | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614 | 2104300 | 37.7583244674077 | -122.423618732861 | (37.7583244674077, -122.423618732861) | 2 | 4 | 5 | 28859 | 19 | ||
| 177826 | 91237 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 808 Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 4x15 | 6005611 | 2104262 | 37.7582199589604 | -122.423626406477 | (37.7582199589604, -122.423626406477) | 2 | 4 | 5 | 28859 | 19 | ||
| 157919 | 91293 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2001 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
| 159812 | 91238 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
| 110959 | 221423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005658.05131 | 2104209.23909 | 37.7580777456208 | -122.423459931529 | (37.7580777456208, -122.423459931529) | 2 | 4 | 5 | 28859 | 19 | |||
| 21108 | 243241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005660.54217 | 2104179.64824 | 37.7579966366535 | -122.423449213415 | (37.7579966366535, -122.423449213415) | 2 | 4 | 5 | 28859 | 19 | |||
| 165700 | 221422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103 | (37.7579289437835, -122.42344282103) | 2 | 4 | 5 | 28859 | 19 | |||
| 6246 | 221421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005663.97142 | 2104121.3615 | 37.7578367884406 | -122.423433209975 | (37.7578367884406, -122.423433209975) | 2 | 4 | 5 | 28859 | 19 | ||
| 103645 | 221420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 5 | Width 3ft | 6005663.71373 | 2104068.90036 | 37.7576927278639 | -122.423430371709 | (37.7576927278639, -122.423430371709) | 2 | 4 | 5 | 28859 | 19 | ||
| 54019 | 91241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 57081 | 91242 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 79544 | 91239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Hanging Pot | Tree | DPW 1 | 11/20/1989 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 191935 | 91240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 81807 | 243240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005663.74872 | 2104041.4182 | 37.7576172702474 | -122.423428296996 | (37.7576172702474, -122.423428296996) | 2 | 4 | 5 | 28859 | 19 | |||
| 115886 | 91243 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 850x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/10/2009 12:00:00 AM | 3 | 6005625 | 2104018 | 37.7575507822519 | -122.423560641088 | (37.7575507822519, -122.423560641088) | 2 | 4 | 5 | 28859 | 19 | |||
| 18108 | 221419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005664.4202 | 2104015.71487 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | 2 | 4 | 5 | 28859 | 19 | ||
| 8919 | 91244 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 852x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:21:00 AM | 3 | 6005625 | 2104006 | 37.7575178330554 | -122.423559787953 | (37.7575178330554, -122.423559787953) | 2 | 4 | 5 | 28859 | 19 | |||
| 9030 | 221418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353201 | -122.423415847665 | (37.757466353201, -122.423415847665) | 2 | 4 | 5 | 28859 | 19 | ||
| 38474 | 243239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005667.36599 | 2103954.71663 | 37.7573794121443 | -122.423409623453 | (37.7573794121443, -122.423409623453) | 2 | 4 | 5 | 28859 | 19 | |||
| 44318 | 91245 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
| 68623 | 91249 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:26:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
| 143846 | 221417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.423384724831 | (37.7571924071266, -122.423384724831) | 2 | 4 | 5 | 28859 | 19 | |||
| 109528 | 91246 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 876x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005633 | 2103862 | 37.7571228942355 | -122.423521883288 | (37.7571228942355, -122.423521883288) | 2 | 4 | 5 | 28859 | 19 | |||
| 7774 | 221416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005677.18728 | 2103848.76992 | 37.7570890615162 | -122.423368126034 | (37.7570890615162, -122.423368126034) | 2 | 4 | 5 | 28859 | 19 | ||
| 57813 | 91247 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 880x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:29:00 AM | 3 | 6005634 | 2103838 | 37.7570570522806 | -122.423516718678 | (37.7570570522806, -122.423516718678) | 2 | 4 | 5 | 28859 | 19 | |||
| 44242 | 221415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005678.5014 | 2103825.14435 | 37.7570242653802 | -122.423361901832 | (37.7570242653802, -122.423361901832) | 2 | 4 | 5 | 28859 | 19 | |||
| 50929 | 91248 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 888x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | 2 | 4 | 5 | 28859 | 19 | |||
| 180105 | 221568 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | 2 | 4 | 5 | 28862 | 3 | |||
| 185336 | 91251 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 906X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.14042 | 2103682.124768 | 37.7566313772663 | -122.423363358583 | (37.7566313772663, -122.423363358583) | 2 | 4 | 5 | 28859 | 19 | ||
| 148907 | 91252 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 908x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.423360407709 | (37.7566004799608, -122.423360407709) | 2 | 4 | 5 | 28859 | 19 | ||
| 981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
| 5313 | 221425 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.423307021613 | (37.7563992716189, -122.423307021613) | 2 | 4 | 5 | 28859 | 19 | |||
| 6810 | 243265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005691.43766 | 2103575.20205 | 37.7563387121803 | -122.42329939627 | (37.7563387121803, -122.42329939627) | 2 | 4 | 5 | 28859 | 19 | ||
| 38198 | 91254 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 928x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.979082 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | 2 | 4 | 5 | 28859 | 19 | ||
| 8628 | 221426 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005693.61577 | 2103548.60767 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | 2 | 4 | 5 | 28859 | 19 | ||
| 2093 | 221427 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.423275433821 | (37.7561368116793, -122.423275433821) | 2 | 4 | 5 | 28859 | 19 | ||
| 123034 | 91255 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
| 159092 | 91256 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
| 29249 | 221506 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.7560668947992 | -122.423269241105 | (37.7560668947992, -122.423269241105) | 2 | 4 | 5 | 28859 | 19 | |||
| 116250 | 221507 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005699.48542 | 2103446.59299 | 37.7559860358317 | -122.42326242244 | (37.7559860358317, -122.42326242244) | 2 | 4 | 5 | 28859 | 19 | |||
| 102302 | 91258 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 948x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047 | 2103445.549621 | 37.7559825338488 | -122.423301390711 | (37.7559825338488, -122.423301390711) | 2 | 4 | 5 | 28859 | 19 | ||
| 43244 | 91259 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 952x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | 2 | 4 | 5 | 28859 | 19 | ||
| 13182 | 243321 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005700.91818 | 2103420.38667 | 37.7559141602344 | -122.423255604682 | (37.7559141602344, -122.423255604682) | 2 | 4 | 5 | 28859 | 19 | ||
| 18001 | 243333 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005703.0197 | 2103377.21002 | 37.7557957257993 | -122.423245267872 | (37.7557957257993, -122.423245267872) | 2 | 4 | 5 | 28859 | 19 | ||
| 96242 | 221567 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | 2 | 4 | 5 | 28862 | 22 | |||
| 10432 | 221544 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005705.62338 | 2103333.32509 | 37.7556753749283 | -122.423233144119 | (37.7556753749283, -122.423233144119) | 2 | 4 | 5 | 28859 | 19 | ||
| 151302 | 91263 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 970x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.423268931776 | (37.7556426634019, -122.423268931776) | 2 | 4 | 5 | 28859 | 19 | ||
| 11768 | 221543 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640819 | (37.7556029507207, -122.42322640819) | 2 | 4 | 5 | 28859 | 19 | |||
| 3021 | 221542 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005709.18006 | 2103278.94714 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | 2 | 4 | 5 | 28859 | 19 | |||
| 51627 | 91264 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 978X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.521495 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );