trees
665 rows where qSpecies_id = 89 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178388 | 203473 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 128 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | 9 | 8 | 6 | 28861 | 24 | |||
| 159986 | 203472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 126 Howth St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.7217288104277 | -122.450411736413 | (37.7217288104277, -122.450411736413) | 9 | 8 | 6 | 28861 | 24 | |||
| 37507 | 17121 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
| 28238 | 31130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.15586 | 37.7295250449277 | -122.448917737661 | (37.7295250449277, -122.448917737661) | 9 | 7 | 4 | 28861 | 40 |
| 63927 | 125438 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 250 Euclid Ave | 0 | Front Yard : Yard | Tree | Private 2 | 15 | 5998091.24108 | 2114006.24691 | 37.78454782955 | -122.450335292242 | (37.78454782955, -122.450335292242) | 15 | 6 | 1 | 54 | 31 | ||||
| 88481 | 203496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998101.39373 | 2095150.67529 | 37.7327757263052 | -122.448941459085 | (37.7327757263052, -122.448941459085) | 9 | 7 | 4 | 59 | 40 | |||
| 170340 | 125439 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 99 Collins St | 0 | Side Yard : Yard | Tree | Private 2 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | 15 | 6 | 1 | 54 | 31 | ||||
| 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 | |||
| 179429 | 203467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 5998177.87228 | 2094421.44457 | 37.7307778050431 | -122.448624552388 | (37.7307778050431, -122.448624552388) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 179693 | 203486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.08817 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 63181 | 203460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998498.64412 | 2094367.64391 | 37.7306484177731 | -122.447511726809 | (37.7306484177731, -122.447511726809) | 9 | 7 | 4 | 28861 | 40 | |||
| 95013 | 203461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 409 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998653.32929 | 2094365.51359 | 37.7306514071182 | -122.446976805539 | (37.7306514071182, -122.446976805539) | 9 | 7 | 4 | 28861 | 40 | |||
| 184630 | 17102 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.447940341436 | (37.771661239802, -122.447940341436) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||||
| 111688 | 203498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999190.87551 | 2094097.92284 | 37.7299473620618 | -122.445099202768 | (37.7299473620618, -122.445099202768) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 128968 | 92753 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.78777 | 37.8021663758311 | -122.446615526285 | (37.8021663758311, -122.446615526285) | 13 | 9 | 1 | 57 | 17 | |
| 14262 | 92752 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 182650 | 88208 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 607 Central Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 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 | |||
| 131214 | 95368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2011 12:00:00 AM | 3x3 | Permit Number 767465 | 5999728 | 2101957 | 37.7515571607552 | -122.443806713729 | (37.7515571607552, -122.443806713729) | 2 | 5 | 5 | 63 | 38 | ||
| 96657 | 220617 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999730.46823 | 2101939.14181 | 37.7515082672912 | -122.443796895437 | (37.7515082672912, -122.443796895437) | 2 | 5 | 5 | 63 | 38 | |||
| 84641 | 88118 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.443725322035 | (37.7516991466356, -122.443725322035) | 2 | 5 | 5 | 63 | 38 | ||
| 159874 | 220616 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999753.1781 | 2101988.06706 | 37.7516438994494 | -122.443721876666 | (37.7516438994494, -122.443721876666) | 2 | 5 | 5 | 63 | 38 | |||
| 138499 | 125449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999876.27718 | 2115725.03781 | 37.7893691777902 | -122.444283251471 | (37.7893691777902, -122.444283251471) | 13 | 6 | 1 | 29490 | 27 | |||
| 167430 | 37576 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918 | (37.7601298795068, -122.44341407918) | 2 | 4 | 5 | 28862 | 3 | ||
| 179888 | 203491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.7337449607507 | -122.442702834189 | (37.7337449607507, -122.442702834189) | 9 | 7 | 4 | 63 | 40 | |||
| 160224 | 203492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | 9 | 7 | 4 | 63 | 40 | |||
| 85417 | 221765 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 165 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000037.69587 | 2106199.41068 | 37.7632234397255 | -122.443040392005 | (37.7632234397255, -122.443040392005) | 15 | 5 | 5 | 28862 | 3 | |||
| 46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
| 148998 | 175154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.441897095593 | (37.7250574153596, -122.441897095593) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 193901 | 175157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
| 82326 | 125441 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6000221.62171 | 2120363.59067 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | 13 | 9 | 1 | 57 | 17 | |||
| 159970 | 220622 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | 2 | 4 | 5 | 28862 | 22 | |||
| 171584 | 220623 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 58 Fountain St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6000335.70641 | 2101336.8621 | 37.7498890559574 | -122.441660695297 | (37.7498890559574, -122.441660695297) | 2 | 4 | 5 | 28862 | 22 | |||
| 170126 | 220628 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.440953463952 | (37.751606143208, -122.440953463952) | 2 | 4 | 5 | 28862 | 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 | |||
| 172501 | 32487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 257 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.08159 | 2106647.67071 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | 15 | 5 | 5 | 28862 | 3 | |
| 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 | |||
| 145209 | 220631 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000591.19408 | 2101959.06133 | 37.7516120185002 | -122.440821836477 | (37.7516120185002, -122.440821836477) | 2 | 4 | 5 | 28862 | 22 | |||
| 183777 | 125442 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3719 Scott St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6000612.64349 | 2121133.322 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | 13 | 9 | 1 | 57 | 17 | |||
| 157420 | 175151 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.7286795733875 | -122.439753131624 | (37.7286795733875, -122.439753131624) | 9 | 7 | 6 | 28861 | 25 | |
| 89611 | 79973 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.86124 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | 9 | 7 | 6 | 28861 | 25 | |
| 183254 | 175152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.39297 | 37.7286399726426 | -122.43966968351 | (37.7286399726426, -122.43966968351) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | |||
| 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 | |||
| 61578 | 106492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1747 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2018 12:00:00 AM | 12 | 3x3 | Permit Number 773396 | 6000787.4 | 2111331.2 | 37.7773567666582 | -122.440815564147 | (37.7773567666582, -122.440815564147) | 15 | 5 | 11 | 29492 | 41 | |
| 106011 | 91377 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 49 Seward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52069 | 6000873 | 2104304 | 37.7580666971462 | -122.440015443053 | (37.7580666971462, -122.440015443053) | 2 | 4 | 5 | 28862 | 38 | |||
| 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 | |||
| 89690 | 17228 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6000994.27294 | 2091122.49333 | 37.721880279621 | -122.438651538532 | (37.721880279621, -122.438651538532) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 151688 | 221758 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001348.57277 | 2104052.25308 | 37.757402522937 | -122.438352676761 | (37.757402522937, -122.438352676761) | 2 | 4 | 5 | 28862 | 3 | |||
| 26980 | 19287 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | 13 | 6 | 1 | 29490 | 27 | |||
| 102500 | 221759 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001360.92884 | 2104054.05926 | 37.7574081850601 | -122.438310074049 | (37.7574081850601, -122.438310074049) | 2 | 4 | 5 | 28862 | 3 | |||
| 154272 | 221760 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.438268978651 | (37.7574116654297, -122.438268978651) | 2 | 4 | 5 | 28862 | 3 | |||
| 169624 | 17031 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.438444795925 | (37.7730732545652, -122.438444795925) | 15 | 5 | 11 | 29492 | 10 | |||
| 141457 | 33132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) | 13 | 9 | 1 | 57 | 17 |
| 86468 | 221761 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4441 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001542.76208 | 2104063.39418 | 37.7574441570438 | -122.437681892224 | (37.7574441570438, -122.437681892224) | 2 | 4 | 5 | 28862 | 3 | |||
| 74822 | 27714 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001610.45471 | 2097108.73364 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 165994 | 221762 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001705.95618 | 2104074.38405 | 37.7574836102927 | -122.437118289774 | (37.7574836102927, -122.437118289774) | 2 | 4 | 5 | 28862 | 3 | |||
| 170280 | 221764 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3809 16th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6001727.44948 | 2106346.39943 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | 15 | 5 | 5 | 28862 | 3 | |||
| 26386 | 221771 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | 2 | 7 | 5 | 63 | 7 | |||
| 160075 | 221770 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.7367285749736 | -122.436194979235 | (37.7367285749736, -122.436194979235) | 2 | 7 | 5 | 63 | 7 | |||
| 178418 | 221769 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||||
| 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 | |||
| 182885 | 203490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001874.24208 | 2094906.20617 | 37.7323195164307 | -122.435880309143 | (37.7323195164307, -122.435880309143) | 9 | 7 | 4 | 63 | 40 | |||
| 129795 | 125436 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001892.57083 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | 13 | 9 | 1 | 57 | 17 | |||
| 30749 | 17018 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.77961 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | 15 | 5 | 11 | 29492 | 10 | ||
| 134327 | 18926 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.436984817806 | (37.7893971628975, -122.436984817806) | 13 | 6 | 1 | 29490 | 27 | |||
| 89453 | 18924 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2675 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 3 | 4x4 | Permit Number 770153 | 6002021.65815 | 2115693.95851 | 37.7894060077371 | -122.436858266107 | (37.7894060077371, -122.436858266107) | 13 | 6 | 1 | 29490 | 27 | |
| 51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );