trees
508 rows where qSpecies_id = 25 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
43646 | 176517 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6006489.32827 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | 9 | 7 | 8 | 309 | 39 | |||
43773 | 21413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | ||||
44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
44632 | 36064 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
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 | |||
46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | |||
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 | ||
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 | |||
63451 | 105311 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.7793822053088 | -122.476225875432 | (37.7793822053088, -122.476225875432) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
69946 | 115126 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |||
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 | |||
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 | |||
76115 | 71877 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2013 12:00:00 AM | 10 | Permit Number 770522 | 5995314.7940966 | 2090940.29616255 | 37.7210552801536 | -122.458270736601 | (37.7210552801536, -122.458270736601) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
77790 | 103262 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511 | 2108178 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | 8 | 4 | 7 | 28853 | 19 | |
79612 | 105962 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6013706.37383 | 2104134.52437 | 37.7583235710722 | -122.395619946844 | (37.7583235710722, -122.395619946844) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | |||
85822 | 48957 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | |||
89613 | 113389 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | |||
89899 | 98256 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 |
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) );