trees
508 rows where qSpecies_id = 25 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158358 | 59931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 521 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 12 | Permit Number 19403 | 5999683.6559 | 2110322.5324 | 37.7745243018378 | -122.444561248652 | (37.7745243018378, -122.444561248652) | 15 | 5 | 11 | 29492 | 16 | |
| 192943 | 59914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 409 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1981 12:00:00 AM | 12 | Permit Number 19383 | 5999728.7839 | 2110019.0941 | 37.773693712339 | -122.444383331369 | (37.773693712339, -122.444383331369) | 15 | 5 | 11 | 29492 | 16 | |
| 11951 | 142340 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.7745244442512 | -122.444402018718 | (37.7745244442512, -122.444402018718) | 15 | 5 | 11 | 29492 | 16 | |||
| 139062 | 142338 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | 15 | 5 | 11 | 29492 | 16 | |||
| 35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
| 88260 | 116598 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 454 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x4 | 5999760.624 | 2110077.6149 | 37.7738562121972 | -122.444277398119 | (37.7738562121972, -122.444277398119) | 15 | 5 | 11 | 29492 | 16 | |||
| 112936 | 142206 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | 15 | 5 | 11 | 29492 | 16 | |||
| 32236 | 32806 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
| 79262 | 32807 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
| 38044 | 255484 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2147 Beach St | : | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | Permit Number 781954 | 5999947.25363 | 2120887.03087 | 37.8035466909489 | -122.444408807729 | (37.8035466909489, -122.444408807729) | 13 | 9 | 1 | 57 | 17 | ||
| 164054 | 67684 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 3.5x6 | Permit Number 31288 | 6000001.77226965 | 2094984.07917219 | 37.7324267912213 | -122.442359437007 | (37.7324267912213, -122.442359437007) | 9 | 7 | 4 | 63 | 40 | ||
| 105998 | 245162 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.442531879899 | (37.7715860006418, -122.442531879899) | 15 | 5 | 11 | 29492 | 9 | |||
| 142128 | 109686 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) | 9 | 7 | 6 | 28861 | 25 |
| 40331 | 45143 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | 15 | 5 | 11 | 29492 | 9 | ||
| 155371 | 225951 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000607.24532 | 2101675.70073 | 37.7508348927316 | -122.440746005644 | (37.7508348927316, -122.440746005644) | 2 | 4 | 5 | 28862 | 22 | |||
| 70921 | 33910 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1456 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1997 12:00:00 AM | Permit Number 37880 | 6000788.78339737 | 2111054.09529381 | 37.7765959861438 | -122.440790896143 | (37.7765959861438, -122.440790896143) | 15 | 5 | 11 | 29492 | 41 | |||
| 41836 | 32486 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.7187841 | 2106514.92813142 | 37.7641354685469 | -122.440289096409 | (37.7641354685469, -122.440289096409) | 15 | 5 | 5 | 28862 | 3 | ||
| 9717 | 56360 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1973 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | 13 | 6 | 1 | 29490 | 27 | |
| 143129 | 225952 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001178.25767 | 2102625.59939 | 37.7534755882504 | -122.438839459988 | (37.7534755882504, -122.438839459988) | 2 | 4 | 5 | 28862 | 22 | |||
| 50795 | 225950 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | 2 | 4 | 5 | 28862 | 22 | |||
| 91431 | 225976 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 348 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001460.81775 | 2103733.76138 | 37.7565344055496 | -122.437941677576 | (37.7565344055496, -122.437941677576) | 2 | 4 | 5 | 28862 | 3 | |||
| 185751 | 225975 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001561.54822 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | 2 | 4 | 5 | 28862 | 3 | |||
| 149327 | 128871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6001562.05606 | 2116003.40074 | 37.7902295241198 | -122.438470613846 | (37.7902295241198, -122.438470613846) | 13 | 6 | 1 | 29490 | 27 | |||
| 2041 | 160444 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001593.49946 | 2090135.39202 | 37.7192039916542 | -122.436509553078 | (37.7192039916542, -122.436509553078) | 9 | 7 | 6 | 28861 | 5 | |
| 179715 | 128870 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.7902522526915 | -122.438346819465 | (37.7902522526915, -122.438346819465) | 13 | 6 | 1 | 29490 | 27 | |||
| 9064 | 160443 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001607.56751 | 2090126.88906 | 37.7191814438384 | -122.436460317003 | (37.7191814438384, -122.436460317003) | 9 | 7 | 6 | 28861 | 5 | |
| 7119 | 160442 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001618.67643 | 2090120.31362 | 37.7191640203955 | -122.436421447404 | (37.7191640203955, -122.436421447404) | 9 | 7 | 6 | 28861 | 5 | |
| 1058 | 160441 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001628.58163 | 2090114.34641 | 37.7191481986061 | -122.436386782123 | (37.7191481986061, -122.436386782123) | 9 | 7 | 6 | 28861 | 5 | |
| 47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 | |||
| 2617 | 247759 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | 15 | 5 | 5 | 29492 | 9 | |||
| 91608 | 50169 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 89@ DUBOCE Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2003 12:00:00 AM | Permit Number 46880 | 6001684.35285968 | 2108342.8233287 | 37.7692024719005 | -122.437498663894 | (37.7692024719005, -122.437498663894) | 15 | 5 | 5 | 29492 | 9 | |||
| 186337 | 128868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001720.521 | 2116028.9102 | 37.790308579028 | -122.437924165962 | (37.790308579028, -122.437924165962) | 13 | 6 | 1 | 29490 | 27 | |||
| 40018 | 105804 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 117 ALPINE TER | 1 | Front Yard : Cutout | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | 15 | 5 | 5 | 29492 | 3 | |
| 119348 | 128867 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | 13 | 6 | 1 | 29490 | 27 | |||
| 49712 | 47473 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.95149 | 37.7901845409254 | -122.437789893616 | (37.7901845409254, -122.437789893616) | 13 | 6 | 1 | 29490 | 27 | |
| 122480 | 38842 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | 15 | 5 | 11 | 29492 | 10 | ||||
| 53060 | 128866 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.7903441535036 | -122.43764656594 | (37.7903441535036, -122.43764656594) | 13 | 6 | 1 | 29490 | 27 | |||
| 68217 | 10694 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.437120398394 | (37.7751414763631, -122.437120398394) | 15 | 5 | 11 | 29492 | 10 | |||
| 119640 | 10695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.437059807317 | (37.7751961745675, -122.437059807317) | 15 | 5 | 11 | 29492 | 10 | |||
| 25269 | 128865 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001864.71047 | 2116045.71849 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | 13 | 6 | 1 | 29490 | 27 | |||
| 96557 | 62524 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 342 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38698 | 6002273.08197673 | 2109652.09551148 | 37.7728308633198 | -122.435555961743 | (37.7728308633198, -122.435555961743) | 15 | 5 | 11 | 29492 | 9 | ||
| 126766 | 22760 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.435696258637 | (37.7801053300032, -122.435696258637) | 15 | 5 | 11 | 29490 | 41 | |||
| 165063 | 67769 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3668 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31399 | 6002481.45062456 | 2106510.50272194 | 37.7642166536125 | -122.434610512105 | (37.7642166536125, -122.434610512105) | 15 | 5 | 5 | 28862 | 3 | ||
| 107170 | 225973 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002948.31867 | 2105450.25596 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | 15 | 4 | 5 | 28862 | 3 | |||
| 124628 | 225974 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002948.60968 | 2105430.29379 | 37.7612771701244 | -122.43291756641 | (37.7612771701244, -122.43291756641) | 15 | 4 | 5 | 28862 | 3 | |||
| 121409 | 225926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002953.29528 | 2099219.15304 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | 2 | 7 | 5 | 63 | 22 | |||
| 23044 | 51908 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.432833581883 | (37.7610905025589, -122.432833581883) | 15 | 4 | 5 | 28862 | 3 |
| 42046 | 51909 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 490X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48114 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.432833581883 | (37.7610905025589, -122.432833581883) | 15 | 4 | 5 | 28862 | 3 | |
| 182243 | 32109 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 431 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002988.87793 | 2105732.43045 | 37.7621090484283 | -122.432799880203 | (37.7621090484283, -122.432799880203) | 15 | 4 | 5 | 28862 | 3 | |
| 119801 | 32107 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 429 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35478 | 6002990.68319 | 2105750.27702 | 37.7621581531882 | -122.432794911471 | (37.7621581531882, -122.432794911471) | 15 | 4 | 5 | 28862 | 3 | |
| 95562 | 32108 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 431 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002991.88762 | 2105721.63802 | 37.7620795857172 | -122.432788699839 | (37.7620795857172, -122.432788699839) | 15 | 4 | 5 | 28862 | 3 | |
| 167735 | 68770 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32698 | 6002993.73826974 | 2104676.98539815 | 37.7592113259791 | -122.432707672319 | (37.7592113259791, -122.432707672319) | 2 | 4 | 5 | 28862 | 3 | ||
| 43247 | 35398 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | 2 | 7 | 5 | 63 | 22 | ||
| 62340 | 95571 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109 | 2102648 | 37.7536467518763 | -122.432164143819 | (37.7536467518763, -122.432164143819) | 2 | 4 | 5 | 28862 | 22 | |
| 91845 | 247455 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | 15 | 9 | 11 | 29492 | 10 | |||
| 93322 | 52137 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.7741324574889 | -122.432633838295 | (37.7741324574889, -122.432633838295) | 15 | 9 | 11 | 29492 | 10 | |
| 7461 | 32089 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3976 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35462 | 6003168.80356063 | 2104788.27114216 | 37.7595268169135 | -122.432110159889 | (37.7595268169135, -122.432110159889) | 2 | 4 | 5 | 28862 | 3 | ||
| 143918 | 32088 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.7595298134806 | -122.431935468059 | (37.7595298134806, -122.431935468059) | 2 | 4 | 5 | 28862 | 3 | |
| 90074 | 244415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 630 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.431511157729 | (37.7729851758016, -122.431511157729) | 15 | 9 | 11 | 29492 | 10 | |||
| 69462 | 67933 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31646 | 6003490.5816971 | 2095075.42432118 | 37.7328758373096 | -122.43030432183 | (37.7328758373096, -122.43030432183) | 9 | 7 | 5 | 28861 | 25 | ||
| 111491 | 95562 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496 | 2099787 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | 2 | 7 | 5 | 63 | 22 | |
| 10451 | 225947 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003497.57041 | 2095097.96573 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | 9 | 7 | 5 | 28861 | 25 | |||
| 72652 | 246444 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003499.43256 | 2099785.66068 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | 2 | 7 | 5 | 63 | 22 | |||
| 30350 | 225979 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | 15 | 9 | 11 | 29492 | 10 | |||
| 67298 | 225972 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003502.63381 | 2105046.72586 | 37.7602553928045 | -122.430974055914 | (37.7602553928045, -122.430974055914) | 2 | 4 | 5 | 28862 | 3 | |||
| 10061 | 171232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 83 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2019 12:00:00 AM | 3 | 4x6 | 6003613.10498 | 2092939.5829 | 37.727018235977 | -122.429728444518 | (37.727018235977, -122.429728444518) | 9 | 7 | 6 | 28861 | 5 | ||
| 53315 | 34425 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.7353641309188 | -122.429928789613 | (37.7353641309188, -122.429928789613) | 2 | 7 | 5 | 63 | 7 | ||
| 5483 | 83664 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/2019 12:00:00 AM | 3 | 3x3 | Permit Number 769750 | 6003631.23676 | 2092962.7354 | 37.7270828342867 | -122.429667413832 | (37.7270828342867, -122.429667413832) | 9 | 7 | 6 | 28861 | 5 |
| 96405 | 225955 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003637.73808 | 2095933.74555 | 37.7352409272147 | -122.429856766083 | (37.7352409272147, -122.429856766083) | 2 | 7 | 5 | 63 | 7 | |||
| 154480 | 225954 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.7351809981922 | -122.429795956641 | (37.7351809981922, -122.429795956641) | 2 | 7 | 5 | 63 | 7 | |||
| 128927 | 225953 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.7351262474841 | -122.429739824559 | (37.7351262474841, -122.429739824559) | 2 | 7 | 5 | 63 | 7 | |||
| 4108 | 171288 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003689.73978 | 2092721.91783 | 37.7264249154698 | -122.429448003531 | (37.7264249154698, -122.429448003531) | 9 | 7 | 6 | 28861 | 5 | ||
| 148769 | 225977 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6003712.20285 | 2103924.72704 | 37.7571865237503 | -122.430169210355 | (37.7571865237503, -122.430169210355) | 2 | 4 | 5 | 28862 | 3 | |||
| 52646 | 59406 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.7340363078834 | -122.42943165971 | (37.7340363078834, -122.42943165971) | 2 | 7 | 5 | 28861 | 25 | ||
| 71850 | 47716 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45512 | 6003756.95954941 | 2095440.56895285 | 37.7338935267661 | -122.429409415665 | (37.7338935267661, -122.429409415665) | 2 | 7 | 5 | 28861 | 25 | ||
| 61119 | 225949 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.7330390388203 | -122.429314984812 | (37.7330390388203, -122.429314984812) | 9 | 7 | 5 | 28861 | 25 | |||
| 45175 | 225948 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6003779.75499 | 2095097.51754 | 37.7329528756765 | -122.429306150766 | (37.7329528756765, -122.429306150766) | 9 | 7 | 5 | 28861 | 25 | |||
| 44918 | 67927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.7330050563948 | -122.429274738173 | (37.7330050563948, -122.429274738173) | 9 | 7 | 5 | 28861 | 25 | ||
| 124151 | 244202 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | 7 | 9 | 11 | 29492 | 10 | |||
| 29499 | 244210 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | 7 | 9 | 11 | 29492 | 10 | |||
| 164760 | 35153 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38684 | 6003946.04415605 | 2109759.28063083 | 37.7732200439593 | -122.429776640335 | (37.7732200439593, -122.429776640335) | 7 | 9 | 11 | 29492 | 10 | ||
| 60037 | 93902 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768056 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||
| 90128 | 72237 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 365 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53060 | 6003968.6918684 | 2103317.11324706 | 37.7555326838578 | -122.429238846799 | (37.7555326838578, -122.429238846799) | 2 | 4 | 5 | 28862 | 22 | ||
| 40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
| 132497 | 95583 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 320 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767373 | 6004245 | 2103375 | 37.7557072655698 | -122.428287412943 | (37.7557072655698, -122.428287412943) | 2 | 4 | 5 | 28862 | 22 | |
| 149538 | 42034 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50466 | 6004260 | 2098933 | 37.7435114157111 | -122.427919028307 | (37.7435114157111, -122.427919028307) | 2 | 7 | 5 | 63 | 22 | |
| 46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 | |||
| 95938 | 128864 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.427790646526 | (37.7760451281037, -122.427790646526) | 7 | 9 | 11 | 28852 | 10 | |||
| 171054 | 140348 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | 7 | 9 | 11 | 29490 | 41 | |||
| 92573 | 128863 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.427772325535 | (37.7759621899439, -122.427772325535) | 7 | 9 | 11 | 28852 | 10 | |||
| 48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
| 53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
| 30868 | 95394 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 208 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579 | 2098715 | 37.7429308791836 | -122.426800483584 | (37.7429308791836, -122.426800483584) | 2 | 7 | 5 | 63 | 22 | |
| 171972 | 115822 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
| 64629 | 142235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | 7 | 9 | 11 | 28852 | 10 | |||
| 67621 | 128862 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 Hayes St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | 7 | 9 | 11 | 28852 | 10 | |||
| 106476 | 225956 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004690.92985 | 2097272.08471 | 37.7389752900871 | -122.426310750952 | (37.7389752900871, -122.426310750952) | 2 | 7 | 5 | 63 | 7 | |||
| 47126 | 60044 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | 2 | 7 | 5 | 63 | 7 | ||
| 95461 | 225927 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 172 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004830.88644 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | 2 | 7 | 5 | 63 | 22 | |||
| 33078 | 52211 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | 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) );