trees
508 rows where qSpecies_id = 25 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 49249 | 176502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678 | (37.7116417355373, -122.42221747678) | 9 | 7 | 8 | 309 | 18 | |||
| 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 | |
| 49729 | 192424 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012214.21558 | 2107593.00345 | 37.767736670334 | -122.401023519214 | (37.767736670334, -122.401023519214) | 14 | 3 | 8 | 28856 | 20 | |||
| 50638 | 192419 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 3 | : | Tree | Private 2 | 8 | Width 5ft | 6013725.78081 | 2104155.14731 | 37.7583812766799 | -122.395554273333 | (37.7583812766799, -122.395554273333) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 51015 | 225924 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6005469.65475 | 2108205.80814 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | 8 | 4 | 5 | 28853 | 19 | |||
| 51655 | 225914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 611 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009855.21876 | 2105398.04081 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | 2 | 4 | 8 | 28859 | 19 | |||
| 52777 | 225919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009340.70254 | 2099660.44823 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 53260 | 10131 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.19449 | 2103799.35315 | 37.7569555760466 | -122.423229711377 | (37.7569555760466, -122.423229711377) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 55179 | 176501 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.422201590246 | (37.7116934016018, -122.422201590246) | 9 | 7 | 8 | 309 | 18 | |||
| 55349 | 115881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.09601 | 37.737410632491 | -122.390459765022 | (37.737410632491, -122.390459765022) | 10 | 3 | 8 | 58 | 1 | ||
| 55505 | 225970 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6009214.74518 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | 2 | 4 | 7 | 28859 | 19 | |||
| 57051 | 225959 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.418365432231 | (37.7377988968125, -122.418365432231) | 2 | 7 | 7 | 28859 | 2 | |
| 57319 | 65448 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.74179 | 37.7873314010144 | -122.463600988074 | (37.7873314010144, -122.463600988074) | 11 | 6 | 1 | 54 | 11 | ||
| 58299 | 225971 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006565.68979 | 2104973.14116 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | 2 | 4 | 7 | 28859 | 19 | |||
| 58362 | 142702 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | 3 | 1 | 10 | 308 | 23 | |||
| 58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
| 59021 | 221893 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.7510043375848 | -122.413092739446 | (37.7510043375848, -122.413092739446) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 62095 | 176509 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | 9 | 7 | 8 | 309 | 39 | |||
| 63017 | 176519 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | 9 | 7 | 8 | 309 | 39 | |||
| 63677 | 10032 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) | 8 | 4 | 5 | 28853 | 19 | |||
| 63701 | 27660 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6005798.59708 | 2101052.03016 | 37.7494167122272 | -122.422749495892 | (37.7494167122272, -122.422749495892) | 2 | 4 | 5 | 28859 | 19 | |||
| 63945 | 225932 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.408573752301 | (37.743730236853, -122.408573752301) | 2 | 7 | 7 | 28859 | 2 | |||
| 64250 | 128879 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012011.13763 | 2118129.24016 | 37.7966553941982 | -122.402466903231 | (37.7966553941982, -122.402466903231) | 3 | 1 | 10 | 28860 | 4 | |||
| 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 | |||
| 64828 | 225913 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.423560032385 | (37.760182844481, -122.423560032385) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 67422 | 225911 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 886 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005643.7507 | 2103817.72642 | 37.7570019361197 | -122.42348155573 | (37.7570019361197, -122.42348155573) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 67816 | 29766 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | 3 | 1 | 10 | 308 | 23 | |||
| 67850 | 140156 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 68866 | 219001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.462201222508 | (37.7655709877426, -122.462201222508) | 11 | 5 | 11 | 56 | 12 | |||
| 70165 | 49767 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008676.28834 | 2086439.38255 | 37.7094554512839 | -122.41176593097 | (37.7094554512839, -122.41176593097) | 9 | 7 | 8 | 309 | 39 | |
| 71647 | 176515 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | 9 | 7 | 8 | 309 | 39 | |||
| 72350 | 225922 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009935.78986 | 2099989.59836 | 37.7467320650326 | -122.408367985612 | (37.7467320650326, -122.408367985612) | 2 | 7 | 7 | 28859 | 2 | |||
| 72540 | 225944 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3386 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005759.14871 | 2103755.79247 | 37.7568383926032 | -122.423078063208 | (37.7568383926032, -122.423078063208) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 72787 | 225929 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.7422258131659 | -122.414443742389 | (37.7422258131659, -122.414443742389) | 2 | 7 | 7 | 28859 | 2 | |||
| 73497 | 192408 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 799 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011594.92882 | 2104699.39002 | 37.7597568913958 | -122.4029620232 | (37.7597568913958, -122.4029620232) | 10 | 3 | 8 | 28856 | 29 | |||
| 74085 | 78433 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2016 12:00:00 AM | 3 | 6011558.92592 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | 10 | 3 | 8 | 28856 | 29 | ||
| 74513 | 10124 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005714.7162163 | 2103867.2939475 | 37.7571420422058 | -122.42323965319 | (37.7571420422058, -122.42323965319) | 2 | 4 | 5 | 28859 | 19 | |||
| 75291 | 421 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | 2 | 4 | 5 | 28859 | 19 | |||
| 76881 | 219007 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995325.39637 | 2091321.08064 | 37.7221014328296 | -122.458261634395 | (37.7221014328296, -122.458261634395) | 9 | 8 | 4 | 28861 | 24 | |||
| 77221 | 32926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1530 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | Permit Number 37252 | 6012714.10584 | 2106606.08517 | 37.765054686045 | -122.399225162022 | (37.765054686045, -122.399225162022) | 14 | 3 | 8 | 28856 | 20 | |
| 81760 | 192405 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012343.89644 | 2104716.44706 | 37.7598455204762 | -122.400372895689 | (37.7598455204762, -122.400372895689) | 10 | 3 | 8 | 28856 | 29 | |||
| 82591 | 219004 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5993378.4627 | 2104217.9895 | 37.7574010390349 | -122.46592829725 | (37.7574010390349, -122.46592829725) | 1 | 8 | 4 | 56 | 12 | |||
| 82691 | 192420 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 4 | : | Tree | Private 2 | 8 | Width 5ft | 6013708.56182 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | 10 | 3 | 8 | 28856 | 29 | |||
| 83440 | 32625 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011878.08124 | 2109949.48586 | 37.7741882789872 | -122.402351882652 | (37.7741882789872, -122.402351882652) | 14 | 2 | 9 | 28853 | 34 | |
| 83523 | 221894 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008618.93304 | 2101573.97925 | 37.7510085904948 | -122.413033569448 | (37.7510085904948, -122.413033569448) | 2 | 4 | 7 | 28859 | 19 | |||
| 83630 | 225921 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900492 | (37.7456982412969, -122.40909900492) | 2 | 7 | 7 | 28859 | 2 | |||
| 83654 | 49830 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | 14 | 3 | 8 | 28856 | 29 | |
| 85249 | 225908 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005343.316 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | 2 | 4 | 5 | 28859 | 19 | |||
| 85756 | 49772 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 6 | Permit Number 46559 | 6008665.3182 | 2086406.55888 | 37.7093647087858 | -122.411801527923 | (37.7093647087858, -122.411801527923) | 9 | 7 | 8 | 309 | 39 | |
| 86316 | 176513 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006276.40846 | 2087403.97862 | 37.7119691058641 | -122.420128742862 | (37.7119691058641, -122.420128742862) | 9 | 7 | 8 | 309 | 39 | |||
| 87206 | 10130 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005717.32362 | 2103778.46659 | 37.7568982901448 | -122.423224321766 | (37.7568982901448, -122.423224321766) | 2 | 4 | 5 | 28859 | 19 | ||
| 87972 | 112871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | 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 | |||
| 88273 | 219005 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | 1 | 8 | 4 | 56 | 12 | |||
| 88947 | 142690 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.8046139862257 | -122.414442971246 | (37.8046139862257, -122.414442971246) | 3 | 1 | 10 | 308 | 23 | |||
| 89880 | 225934 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | 2 | 4 | 7 | 28859 | 19 | |||
| 90032 | 10155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 91462 | 245459 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | 8 | 4 | 7 | 28853 | 19 | |||
| 91533 | 32276 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | 6x6 | Permit Number 37277 | 6014077.27946 | 2105468.87126 | 37.7620080221813 | -122.394430611806 | (37.7620080221813, -122.394430611806) | 10 | 3 | 8 | 28856 | 29 |
| 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 | |||
| 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 | |||
| 92905 | 128873 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | 5 | 1 | 10 | 28857 | 21 | |||
| 93375 | 245456 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007901.4813 | 2106811.8898 | 37.7653503913435 | -122.415885464882 | (37.7653503913435, -122.415885464882) | 8 | 4 | 7 | 28853 | 19 | |||
| 93399 | 32626 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | 14 | 2 | 9 | 28853 | 34 | |
| 94079 | 10152 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005742.33218 | 2103287.18966 | 37.7555507693625 | -122.423102914188 | (37.7555507693625, -122.423102914188) | 2 | 4 | 5 | 28859 | 19 | |||
| 94709 | 219008 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | Permit Number 781866 | 5995303 | 2091035 | 37.7213146365991 | -122.45831835627 | (37.7213146365991, -122.45831835627) | 9 | 8 | 6 | 28861 | 24 | ||
| 94859 | 192414 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.7604149289253 | -122.402245819308 | (37.7604149289253, -122.402245819308) | 10 | 3 | 8 | 28856 | 29 | |||
| 95128 | 67495 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1126 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 18 | Permit Number 31020 | 6011901.71261 | 2103178.79248 | 37.7555987922788 | -122.401794116823 | (37.7555987922788, -122.401794116823) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 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 | |
| 95703 | 176506 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005608.52394 | 2087094.53344 | 37.7110817807597 | -122.42241517113 | (37.7110817807597, -122.42241517113) | 9 | 7 | 8 | 309 | 18 | |||
| 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 | |||
| 96105 | 10071 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | 8 | 4 | 5 | 28859 | 19 | |||
| 96140 | 225960 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.414773468947 | (37.7383428544349, -122.414773468947) | 2 | 7 | 7 | 28859 | 2 | |||
| 96307 | 142724 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008368.8817 | 2121063.6546 | 37.8045085593837 | -122.415277798263 | (37.8045085593837, -122.415277798263) | 5 | 1 | 10 | 308 | 23 | |||
| 96340 | 225941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008479.57157 | 2106789.99356 | 37.7653227523561 | -122.413884429728 | (37.7653227523561, -122.413884429728) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 96423 | 142687 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.8046368316065 | -122.414289624157 | (37.8046368316065, -122.414289624157) | 3 | 1 | 10 | 308 | 23 | |||
| 96662 | 225899 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009375.43724 | 2107898.55121 | 37.7684168680618 | -122.41086412858 | (37.7684168680618, -122.41086412858) | 8 | 4 | 7 | 28853 | 19 | |||
| 96869 | 239616 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 998 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009140.95631 | 2103384.46491 | 37.756009068389 | -122.411356242114 | (37.756009068389, -122.411356242114) | 2 | 4 | 7 | 28859 | 19 | |||
| 98073 | 192411 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.402369426605 | (37.7615462436837, -122.402369426605) | 10 | 3 | 8 | 28856 | 29 | |||
| 98749 | 59936 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1757 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 14 | Permit Number 19409 | 5999437.2024 | 2110127.1563 | 37.7739737829513 | -122.44539972496 | (37.7739737829513, -122.44539972496) | 15 | 5 | 11 | 29492 | 16 | |
| 99644 | 225943 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3386 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005777.63765 | 2103756.42358 | 37.75684116881 | -122.423014166371 | (37.75684116881, -122.423014166371) | 2 | 4 | 5 | 28859 | 19 | |||
| 99856 | 48556 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | 15 | 5 | 11 | 29492 | 16 | |
| 100419 | 142692 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 590x Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008663 | 2121123 | 37.8046880323907 | -122.414264173266 | (37.8046880323907, -122.414264173266) | 3 | 1 | 10 | 308 | 23 | |||
| 100531 | 225930 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.419377573329 | (37.7412874920181, -122.419377573329) | 2 | 7 | 7 | 28859 | 2 | |||
| 101446 | 176503 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.7115691233988 | -122.422243953714 | (37.7115691233988, -122.422243953714) | 9 | 7 | 8 | 309 | 18 | |||
| 101588 | 142725 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 620 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008308.3331 | 2121058.3433 | 37.8044905727941 | -122.41548695656 | (37.8044905727941, -122.41548695656) | 5 | 1 | 10 | 308 | 23 | |||
| 101930 | 225902 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 44 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005679.36245 | 2106382.2556 | 37.7640455405875 | -122.423540717652 | (37.7640455405875, -122.423540717652) | 8 | 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) );