trees
665 rows where qSpecies_id = 89 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1264 | 125499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007355.47144 | 2119286.08851 | 37.7995708047014 | -122.418658671469 | (37.7995708047014, -122.418658671469) | 5 | 1 | 1 | 28858 | 32 | ||||
| 1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
| 3711 | 125506 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | 3 | 1 | 10 | 308 | 21 | |||
| 4866 | 220627 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002180.12335 | 2102046.50109 | 37.7519424707911 | -122.435333378334 | (37.7519424707911, -122.435333378334) | 2 | 4 | 5 | 28862 | 22 | |||
| 6257 | 125500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.418954327193 | (37.7995302219096, -122.418954327193) | 5 | 1 | 1 | 28858 | 32 | ||||
| 8154 | 220632 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.7468036087954 | -122.435084618683 | (37.7468036087954, -122.435084618683) | 2 | 7 | 5 | 63 | 22 | |||
| 9079 | 220625 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002079.84367 | 2102040.673 | 37.7519207728238 | -122.43567974235 | (37.7519207728238, -122.43567974235) | 2 | 4 | 5 | 28862 | 22 | |||
| 10180 | 125521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008568.41134 | 2119026.06198 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | 5 | 1 | 10 | 308 | 32 | |||
| 13926 | 176734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.415256704327 | (37.7245056282085, -122.415256704327) | 9 | 3 | 7 | 309 | 28 | ||
| 14764 | 203487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 828 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998282.18197 | 2096469.86688 | 37.736408249925 | -122.448411398672 | (37.736408249925, -122.448411398672) | 9 | 7 | 4 | 59 | 40 | |||
| 15503 | 221757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2 Seward St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.439332593347 | (37.7579519799282, -122.439332593347) | 2 | 4 | 5 | 28862 | 38 | |||
| 15512 | 203483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.7332258441801 | -122.457954104018 | (37.7332258441801, -122.457954104018) | 9 | 7 | 4 | 59 | 40 | |||
| 20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
| 23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
| 24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
| 24271 | 125480 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 70 Pleasant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008592.70141 | 2116811.84206 | 37.7928467140568 | -122.414202246537 | (37.7928467140568, -122.414202246537) | 5 | 1 | 10 | 28857 | 21 | |||
| 24487 | 125483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1471 Washington St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007681.40554 | 2117137.66068 | 37.7936901018702 | -122.417378482047 | (37.7936901018702, -122.417378482047) | 5 | 1 | 10 | 28858 | 32 | |||
| 24813 | 125514 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008590.31929 | 2119027.39259 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | 5 | 1 | 10 | 308 | 32 | |||
| 27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
| 27574 | 203500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | 9 | 7 | 4 | 63 | 40 | |||
| 34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
| 35518 | 125505 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6007613.99229 | 2119386.63886 | 37.7998614422209 | -122.41777122496 | (37.7998614422209, -122.41777122496) | 5 | 1 | 1 | 28858 | 32 | ||||
| 36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
| 40013 | 203466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5998189.16786 | 2094420.93356 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | 9 | 7 | 4 | 59 | 40 | |||
| 48346 | 203469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998711.43854 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | 9 | 7 | 4 | 28861 | 40 | ||||
| 48353 | 175174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003793.29108 | 2091173.56486 | 37.7221793437874 | -122.428979687879 | (37.7221793437874, -122.428979687879) | 9 | 7 | 6 | 28861 | 5 | |||
| 48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
| 49839 | 175172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003774.22148 | 2091143.66189 | 37.7220961573958 | -122.42904347589 | (37.7220961573958, -122.42904347589) | 9 | 7 | 6 | 28861 | 5 | |||
| 50122 | 125517 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008575.41519 | 2119026.37821 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | 5 | 1 | 10 | 308 | 32 | |||
| 51514 | 125509 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.414218814773 | (37.7989402522368, -122.414218814773) | 5 | 1 | 10 | 308 | 32 | |||
| 51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
| 55157 | 125470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.7907910167417 | -122.409017984115 | (37.7907910167417, -122.409017984115) | 5 | 1 | 10 | 28857 | 21 | |||
| 55814 | 125511 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008625.76186 | 2119029.22421 | 37.7989369553212 | -122.414244810558 | (37.7989369553212, -122.414244810558) | 5 | 1 | 10 | 308 | 32 | |||
| 56067 | 203470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999333.68862 | 2093807.88656 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | 9 | 7 | 4 | 28861 | 40 | ||||
| 59297 | 125452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | 13 | 9 | 1 | 29490 | 27 | |||
| 64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
| 64506 | 125523 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 6011207.16585 | 2120734.52957 | 37.8037639692824 | -122.405432414094 | (37.8037639692824, -122.405432414094) | 3 | 1 | 10 | 308 | 23 | |||
| 64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
| 64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 | |||
| 66854 | 220621 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 714 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001868.87894 | 2099747.43156 | 37.7456120907355 | -122.43624518749 | (37.7456120907355, -122.43624518749) | 2 | 7 | 5 | 63 | 22 | |||
| 67061 | 220629 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000561.39368 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | 2 | 4 | 5 | 28862 | 22 | |||
| 67376 | 220630 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 901 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000579.18981 | 2101957.47614 | 37.7516069822848 | -122.44086323496 | (37.7516069822848, -122.44086323496) | 2 | 4 | 5 | 28862 | 22 | |||
| 70682 | 125454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002093.86703 | 2117345.78422 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | 13 | 9 | 1 | 29490 | 27 | |||
| 71615 | 125510 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.7989384014533 | -122.414228184789 | (37.7989384014533, -122.414228184789) | 5 | 1 | 10 | 308 | 32 | |||
| 72741 | 125513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008593.29487 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | 5 | 1 | 10 | 308 | 32 | |||
| 73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
| 75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
| 76065 | 175158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.441868929714 | (37.7250771680567, -122.441868929714) | 9 | 7 | 6 | 28861 | 25 | |||
| 76702 | 125458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.7940183094364 | -122.436069543591 | (37.7940183094364, -122.436069543591) | 13 | 9 | 1 | 29490 | 27 | |||
| 77046 | 203495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999677.59639 | 2094931.24105 | 37.7322632278502 | -122.443476391437 | (37.7322632278502, -122.443476391437) | 9 | 7 | 4 | 63 | 40 | |||
| 77941 | 125515 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | 5 | 1 | 10 | 308 | 32 | |||
| 78299 | 220619 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 618 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6001863.58646 | 2099454.05886 | 37.7448062577002 | -122.436242496718 | (37.7448062577002, -122.436242496718) | 2 | 7 | 5 | 63 | 22 | ||||
| 80095 | 125508 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008930.42147 | 2118571.4914 | 37.7976972425915 | -122.413158199313 | (37.7976972425915, -122.413158199313) | 3 | 1 | 10 | 308 | 21 | |||
| 81158 | 203493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | 9 | 7 | 4 | 59 | 40 | |||
| 83370 | 175160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | 9 | 7 | 6 | 28861 | 25 | |||
| 84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
| 84672 | 175155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | 9 | 7 | 6 | 28861 | 25 | |||
| 84837 | 203444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995221.10472 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | 9 | 7 | 4 | 59 | 40 | |||
| 86050 | 221773 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | 2 | 7 | 5 | 63 | 7 | |||
| 86571 | 125453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.436780510733 | (37.793936248105, -122.436780510733) | 13 | 9 | 1 | 29490 | 27 | |||
| 87363 | 125495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.8023826214287 | -122.423246597049 | (37.8023826214287, -122.423246597049) | 5 | 9 | 1 | 28858 | 32 | |||
| 88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
| 89424 | 203484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | 9 | 7 | 4 | 59 | 40 | |||
| 90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
| 91938 | 220626 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002107.5344 | 2102041.80892 | 37.7519254645963 | -122.435584065276 | (37.7519254645963, -122.435584065276) | 2 | 4 | 5 | 28862 | 22 | |||
| 95831 | 125519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.7989271266439 | -122.414431021472 | (37.7989271266439, -122.414431021472) | 5 | 1 | 10 | 308 | 32 | |||
| 97812 | 125456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.7939566501408 | -122.436691221543 | (37.7939566501408, -122.436691221543) | 13 | 9 | 1 | 29490 | 27 | |||
| 98062 | 117918 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.7748609268346 | -122.501665678898 | (37.7748609268346, -122.501665678898) | 11 | 6 | 2 | 55 | 26 | |||
| 98841 | 175159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000090.18527 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | 9 | 7 | 6 | 28861 | 25 | |||
| 100066 | 220651 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Stoneman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6008064.96703 | 2099392.46104 | 37.7449875169768 | -122.414794870981 | (37.7449875169768, -122.414794870981) | 2 | 7 | 7 | 28859 | 2 | |||
| 100507 | 175171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003766.26192 | 2091125.79977 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | 9 | 7 | 6 | 28861 | 5 | |||
| 103260 | 175173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003787.7125 | 2091165.48018 | 37.7221568292683 | -122.428998395553 | (37.7221568292683, -122.428998395553) | 9 | 7 | 6 | 28861 | 5 | |||
| 103751 | 175153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6001323.55262 | 2092431.04941 | 37.7254920046417 | -122.437606970601 | (37.7254920046417, -122.437606970601) | 9 | 7 | 6 | 28861 | 25 | |||
| 107415 | 203468 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 2ft | 5998155.09728 | 2094421.38368 | 37.7307763355428 | -122.448703284436 | (37.7307763355428, -122.448703284436) | 9 | 7 | 4 | 59 | 40 | |||
| 111278 | 175161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000095.42068 | 2092313.25863 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | 9 | 7 | 6 | 28861 | 25 | |||
| 111284 | 189200 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 625 Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.386079860717 | (37.7392011179238, -122.386079860717) | 10 | 3 | 8 | 58 | 1 | |||
| 113174 | 125497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6006282.86688 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | 5 | 9 | 1 | 28858 | 32 | |||
| 115613 | 220624 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 665 Elizabeth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6002066.32428 | 2102040.31203 | 37.7519190137697 | -122.435726468425 | (37.7519190137697, -122.435726468425) | 2 | 4 | 5 | 28862 | 22 | |||
| 116507 | 203463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.7310154446029 | -122.439646720241 | (37.7310154446029, -122.439646720241) | 9 | 7 | 4 | 63 | 40 | |||
| 117582 | 203446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.70657 | 2097826.55093 | 37.7399577427547 | -122.459101255842 | (37.7399577427547, -122.459101255842) | 9 | 7 | 4 | 59 | 40 | |||
| 121196 | 125494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | 5 | 9 | 1 | 28858 | 32 | |||
| 121531 | 203462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.439646720213 | (37.7309725397368, -122.439646720213) | 9 | 7 | 4 | 63 | 40 | |||
| 122767 | 220633 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | 2 | 7 | 5 | 63 | 22 | |||
| 124968 | 221767 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 287 Hermann St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | 7 | 9 | 5 | 29492 | 10 | |||
| 125410 | 175162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000098.01412 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | 9 | 7 | 6 | 28861 | 25 | |||
| 127529 | 203465 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5998202.03163 | 2094421.35153 | 37.7307789309899 | -122.448541023359 | (37.7307789309899, -122.448541023359) | 9 | 7 | 4 | 59 | 40 | |||
| 130988 | 125455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | 13 | 9 | 1 | 29490 | 27 | |||
| 131179 | 125473 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | 5 | 1 | 10 | 28857 | 21 | |||
| 131367 | 221774 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | 2 | 7 | 5 | 63 | 7 | |||
| 132440 | 125450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.7940985496517 | -122.44069290605 | (37.7940985496517, -122.44069290605) | 13 | 9 | 1 | 57 | 27 | |||
| 133109 | 175164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000102.23368 | 2092318.39014 | 37.7251131517233 | -122.441820869043 | (37.7251131517233, -122.441820869043) | 9 | 7 | 6 | 28861 | 25 | |||
| 133463 | 203485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | 9 | 7 | 4 | 59 | 40 | |||
| 136754 | 220618 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 237 Murray St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6005720.29652 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | 2 | 7 | 7 | 28861 | 2 | |||
| 142702 | 203494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 363 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999675.09138 | 2094930.6164 | 37.732261369848 | -122.443485006944 | (37.732261369848, -122.443485006944) | 9 | 7 | 4 | 63 | 40 | |||
| 143706 | 125451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001095.19419 | 2117566.78183 | 37.7944955940578 | -122.440198075675 | (37.7944955940578, -122.440198075675) | 13 | 9 | 1 | 57 | 27 | |||
| 144199 | 203464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5999389.85516 | 2094399.06798 | 37.7307855913786 | -122.444432942737 | (37.7307855913786, -122.444432942737) | 9 | 7 | 4 | 59 | 40 | ||||
| 144847 | 125525 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | 3 | 1 | 10 | 308 | 23 | |||
| 146670 | 125518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | 5 | 1 | 10 | 308 | 32 | |||
| 147929 | 175156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | 9 | 7 | 6 | 28861 | 25 | |||
| 148572 | 220620 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 747 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783 | (37.745417306567, -122.43682864783) | 2 | 7 | 5 | 63 | 22 |
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) );