trees
3,247 rows where qSpecies_id = 22 sorted by Longitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194143 | 118792 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 746 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5982002.3368 | 2110652.98782 | 37.7744068613492 | -122.505747814892 | (37.7744068613492, -122.505747814892) | 11 | 6 | 2 | 55 | 26 | ||||
60369 | 250996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 453 44th Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5982195.03644 | 2112765.40351 | 37.780218274692 | -122.505237834779 | (37.780218274692, -122.505237834779) | 11 | 6 | 2 | 55 | 26 | |||
42742 | 81988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 442 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50000 | 5982237.66367 | 2112787.15702 | 37.7802805115522 | -122.505091982727 | (37.7802805115522, -122.505091982727) | 11 | 6 | 2 | 55 | 26 | |
76580 | 47442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 635 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 1 | Permit Number 45353 | 5982550.52878 | 2111435.68847 | 37.7765881781327 | -122.50390953034 | (37.7765881781327, -122.50390953034) | 11 | 6 | 2 | 55 | 26 | |
4067 | 37077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1278 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39679 | 5982458.52457533 | 2106416.34966851 | 37.7628011138985 | -122.503855957317 | (37.7628011138985, -122.503855957317) | 1 | 8 | 3 | 56 | 35 | |
68271 | 40208 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 837 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 2 | Permit Number 41390 | 5982597.67837 | 2110065.01831 | 37.772827489399 | -122.503644899237 | (37.772827489399, -122.503644899237) | 11 | 6 | 2 | 55 | 26 | |
45297 | 117880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 614 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982902.29229 | 2111583.1189 | 37.7770136572268 | -122.502703613921 | (37.7770136572268, -122.502703613921) | 11 | 6 | 2 | 55 | 26 | |||
82084 | 63001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1223 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23409 | 5983019.7565 | 2106777.9999 | 37.7638270872907 | -122.501941646106 | (37.7638270872907, -122.501941646106) | 1 | 8 | 3 | 56 | 35 | ||
191948 | 183347 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1219 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983021.011 | 2106794.309 | 37.7638719411282 | -122.501938514072 | (37.7638719411282, -122.501938514072) | 1 | 8 | 3 | 56 | 35 | |||
30714 | 82147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 861 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52672 | 5983843.06359 | 2109965.10906 | 37.7726263101648 | -122.499329652192 | (37.7726263101648, -122.499329652192) | 11 | 6 | 2 | 55 | 26 | |
46735 | 117831 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5983887.65647 | 2110080.17277 | 37.7729448580991 | -122.499183906831 | (37.7729448580991, -122.499183906831) | 11 | 6 | 2 | 55 | 26 | |||
156162 | 102375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983887.37527 | 2110050.49294 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | 11 | 6 | 2 | 55 | 26 | ||||
165276 | 102374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | 11 | 6 | 2 | 55 | 26 | ||||
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
162442 | 255923 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 539 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2018 12:00:00 AM | 3 | Permit Number 774708 | 5984698.21016 | 2112191.31166 | 37.7787889555839 | -122.496535962511 | (37.7787889555839, -122.496535962511) | 11 | 6 | 2 | 55 | 26 | ||
86452 | 21229 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2392X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
134082 | 21227 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2392X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
136711 | 21226 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2392X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
87544 | 250770 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247 32nd Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5985863.4711 | 2114256.40781 | 37.7845273142332 | -122.492657058592 | (37.7845273142332, -122.492657058592) | 11 | 6 | 1 | 55 | 33 | |||
97723 | 250844 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 242 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986530.96095 | 2114207.27352 | 37.7844314123243 | -122.490344186658 | (37.7844314123243, -122.490344186658) | 11 | 6 | 1 | 55 | 33 | |||
15866 | 87230 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
99391 | 87231 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
109781 | 120013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 377 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5986822.04697 | 2113431.99077 | 37.7823197042456 | -122.489280120977 | (37.7823197042456, -122.489280120977) | 11 | 6 | 2 | 55 | 26 | |||
10689 | 120012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 379 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5986824.09694 | 2113410.67303 | 37.7822612914883 | -122.489271461219 | (37.7822612914883, -122.489271461219) | 11 | 6 | 2 | 55 | 26 | |||
54439 | 183736 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2267 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986978.4063 | 2099834.6763 | 37.7449943609019 | -122.487739916269 | (37.7449943609019, -122.487739916269) | 1 | 8 | 3 | 29491 | 35 | |||
121723 | 116843 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2571 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987034.8 | 2097780.1 | 37.7393563293641 | -122.487394029182 | (37.7393563293641, -122.487394029182) | 1 | 8 | 3 | 29491 | 35 | |
170568 | 57807 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2571 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987052.3077 | 2097770.09 | 37.7393298655452 | -122.487332761031 | (37.7393298655452, -122.487332761031) | 1 | 8 | 3 | 29491 | 35 | |
133525 | 120059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 126 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5987428.00047 | 2115126.85711 | 37.7870086753365 | -122.48730834766 | (37.7870086753365, -122.48730834766) | 11 | 6 | 1 | 55 | 33 | |||
98232 | 117099 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 358 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5987483.76011 | 2113562.21941 | 37.7827158788173 | -122.48700048333 | (37.7827158788173, -122.48700048333) | 11 | 6 | 2 | 55 | 26 | |||
104049 | 67956 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 823 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31675 | 5987552.59212802 | 2110344.39283654 | 37.7738846484949 | -122.486526019249 | (37.7738846484949, -122.486526019249) | 11 | 6 | 2 | 55 | 26 | ||
36550 | 47212 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 6200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2005 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | 11 | 6 | 2 | 55 | 26 | ||
72428 | 47211 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 6200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2005 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | 11 | 6 | 2 | 55 | 26 | ||
78455 | 47210 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 6200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | 11 | 6 | 2 | 55 | 26 | ||
53157 | 95927 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 593 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767624 | 5987807.15035 | 2111962.63313 | 37.7783427176202 | -122.48576426585 | (37.7783427176202, -122.48576426585) | 11 | 6 | 2 | 55 | 26 |
78730 | 12852 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2425 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2017 07:41:00 AM | 3 | 3X3 | 5987893.29403 | 2114620.09876 | 37.785644384199 | -122.485661351291 | (37.785644384199, -122.485661351291) | 11 | 6 | 2 | 55 | 26 | ||
159373 | 182052 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1358 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987745.1727 | 2106038.1892 | 37.7620722288704 | -122.485543778891 | (37.7620722288704, -122.485543778891) | 1 | 8 | 3 | 56 | 35 | |||
87989 | 86916 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
106130 | 86915 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
160182 | 86914 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
186117 | 86913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2300 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | 1 | 8 | 3 | 29491 | 35 | ||
41723 | 181858 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987680.2773 | 2099613.4688 | 37.7444278975301 | -122.485296775017 | (37.7444278975301, -122.485296775017) | 1 | 8 | 3 | 29491 | 35 | |||
113571 | 181859 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1689 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987694.8294 | 2099613.8072 | 37.7444296744268 | -122.485246482324 | (37.7444296744268, -122.485246482324) | 1 | 8 | 3 | 29491 | 35 | |||
67629 | 84233 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 235 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52252 | 5988025.39868397 | 2114411.05493653 | 37.7850781058054 | -122.485188969204 | (37.7850781058054, -122.485188969204) | 11 | 6 | 2 | 55 | 26 | ||
106083 | 181860 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1679 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987725.2874 | 2099613.8072 | 37.7444314487039 | -122.48514116618 | (37.7444314487039, -122.48514116618) | 1 | 8 | 3 | 29491 | 35 | |||
54769 | 34225 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52249 | 5988056.05348 | 2115056.1881 | 37.7868512432119 | -122.485130265467 | (37.7868512432119, -122.485130265467) | 11 | 6 | 1 | 55 | 33 | |
123406 | 84232 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 144 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52250 | 5988057.00135 | 2115013.9222 | 37.7867352483332 | -122.48512388384 | (37.7867352483332, -122.48512388384) | 11 | 6 | 1 | 55 | 33 | |
8137 | 84234 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | 11 | 6 | 2 | 55 | 26 | ||
55634 | 181861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1669 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987765.2212 | 2099616.5146 | 37.7444412086369 | -122.485003283678 | (37.7444412086369, -122.485003283678) | 1 | 8 | 3 | 29491 | 35 | |||
6684 | 32355 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 2 | Permit Number 36909 | 5988077.70341 | 2112909.74205 | 37.7809589730845 | -122.484897834483 | (37.7809589730845, -122.484897834483) | 11 | 6 | 2 | 55 | 26 | |
194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
9388 | 84237 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | 11 | 6 | 2 | 55 | 26 | |||
190362 | 84252 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 525 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51823 | 5988096.43672 | 2112373.30059 | 37.7794871472518 | -122.484793663147 | (37.7794871472518, -122.484793663147) | 11 | 6 | 2 | 55 | 26 | |
171429 | 84240 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 559 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51827 | 5988105.14726 | 2112161.86234 | 37.778907104657 | -122.484748015267 | (37.778907104657, -122.484748015267) | 11 | 6 | 2 | 55 | 26 | |
139410 | 84247 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 573 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51829 | 5988106.91246 | 2112101.51452 | 37.7787415093277 | -122.484737480704 | (37.7787415093277, -122.484737480704) | 11 | 6 | 2 | 55 | 26 | |
133825 | 84248 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 575 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52254 | 5988107.4199 | 2112077.58194 | 37.7786758267484 | -122.484733969212 | (37.7786758267484, -122.484733969212) | 11 | 6 | 2 | 55 | 26 | |
17138 | 84246 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 583 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51830 | 5988110.57341 | 2112018.88919 | 37.7785148566216 | -122.484718753523 | (37.7785148566216, -122.484718753523) | 11 | 6 | 2 | 55 | 26 | |
5489 | 84255 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 591 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51832 | 5988111.36438 | 2111976.41893 | 37.7783982912941 | -122.484712901029 | (37.7783982912941, -122.484712901029) | 11 | 6 | 2 | 55 | 26 | |
56626 | 88396 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 635 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.305185 | 2111648.444046 | 37.7774989839242 | -122.484616395841 | (37.7774989839242, -122.484616395841) | 11 | 6 | 2 | 55 | 26 | |||
82278 | 84256 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 530 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51824 | 5988154.66782 | 2112350.19785 | 37.7794271049068 | -122.484590524432 | (37.7794271049068, -122.484590524432) | 11 | 6 | 2 | 55 | 26 | |
80231 | 84245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 546 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51825 | 5988156.49363 | 2112255.06762 | 37.7791660104002 | -122.484577228457 | (37.7791660104002, -122.484577228457) | 11 | 6 | 2 | 55 | 26 | |
148550 | 56487 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 554 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51826 | 5988158.72366 | 2112206.88577 | 37.7790338464631 | -122.484565978844 | (37.7790338464631, -122.484565978844) | 11 | 6 | 2 | 55 | 26 | |
171771 | 84243 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51828 | 5988163.02484 | 2112103.01758 | 37.778748904105 | -122.484543478761 | (37.778748904105, -122.484543478761) | 11 | 6 | 2 | 55 | 26 | |
69022 | 120211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 586 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5988168.83389 | 2111986.60487 | 37.7784296058096 | -122.48451484226 | (37.7784296058096, -122.48451484226) | 11 | 6 | 2 | 55 | 26 | |||
118087 | 84250 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51831 | 5988169.58035 | 2111959.06238 | 37.7783540253404 | -122.484510239281 | (37.7783540253404, -122.484510239281) | 11 | 6 | 2 | 55 | 26 | |
34317 | 84261 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 751 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51837 | 5988150.92473 | 2110870.15339 | 37.7753631000589 | -122.484494885291 | (37.7753631000589, -122.484494885291) | 11 | 6 | 2 | 55 | 26 | |
146844 | 89206 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 751 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51837 | 5988151.59257 | 2110851.24379 | 37.7753112184725 | -122.484491187824 | (37.7753112184725, -122.484491187824) | 11 | 6 | 2 | 55 | 26 | |
6702 | 84260 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 660 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988186.45102 | 2111472.04935 | 37.777017806636 | -122.484416148832 | (37.777017806636, -122.484416148832) | 11 | 6 | 2 | 55 | 26 | |||
26808 | 89205 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 662 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51833 | 5988199 | 2111465.2 | 37.7769997309607 | -122.48437223608 | (37.7769997309607, -122.48437223608) | 11 | 6 | 2 | 55 | 26 | |||
111170 | 84259 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51834 | 5988199 | 2111465 | 37.7769991818167 | -122.484372221408 | (37.7769991818167, -122.484372221408) | 11 | 6 | 2 | 55 | 26 | |
48193 | 84264 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 706 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51836 | 5988196.19681756 | 2111153.20352169 | 37.7761429127735 | -122.48435904479 | (37.7761429127735, -122.48435904479) | 11 | 6 | 2 | 55 | 26 | ||
85496 | 84271 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 849 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51840 | 5988175.82653 | 2110179.27187 | 37.7734675822134 | -122.484358062894 | (37.7734675822134, -122.484358062894) | 11 | 6 | 2 | 55 | 26 | |
67813 | 84268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 839 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51839 | 5988177.45887 | 2110243.64251 | 37.7736444211087 | -122.484357138502 | (37.7736444211087, -122.484357138502) | 11 | 6 | 2 | 55 | 26 | |
56287 | 84236 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52255 | 5988243.61998404 | 2113329.74294271 | 37.7821218391843 | -122.484354667324 | (37.7821218391843, -122.484354667324) | 11 | 6 | 2 | 55 | 26 | ||
46556 | 182716 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1707 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988092.0603 | 2103661.619 | 37.7555670168906 | -122.484169748346 | (37.7555670168906, -122.484169748346) | 1 | 8 | 3 | 56 | 35 | |||
166372 | 84272 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 882 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51842 | 5988237.36583 | 2109972.33826 | 37.7729029832415 | -122.484130013867 | (37.7729029832415, -122.484130013867) | 11 | 6 | 2 | 55 | 26 | |
14531 | 84257 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.484103215339 | (37.7727438112406, -122.484103215339) | 11 | 6 | 2 | 55 | 26 | |||
180015 | 49941 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2474@ ULLOA 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 1 | Permit Number 46699 | 5988007.7004 | 2098472.4797 | 37.7413141115718 | -122.484080972394 | (37.7413141115718, -122.484080972394) | 1 | 8 | 3 | 29491 | 35 | |
76345 | 120471 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988434.04491 | 2115070.90864 | 37.7869136727274 | -122.483823598526 | (37.7869136727274, -122.483823598526) | 11 | 6 | 1 | 55 | 33 | |||
123296 | 120472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988447.19453 | 2115067.03638 | 37.786903806069 | -122.483777820382 | (37.786903806069, -122.483777820382) | 11 | 6 | 1 | 55 | 33 | |||
151774 | 120473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988459.1629 | 2115064.18747 | 37.7868966804599 | -122.483736204114 | (37.7868966804599, -122.483736204114) | 11 | 6 | 1 | 55 | 33 | |||
176885 | 120474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988469.71157 | 2115060.56996 | 37.7868873618402 | -122.483699443255 | (37.7868873618402, -122.483699443255) | 11 | 6 | 1 | 55 | 33 | |||
150408 | 120460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988559.61165 | 2114998.49915 | 37.7867221656327 | -122.483383861528 | (37.7867221656327, -122.483383861528) | 11 | 6 | 1 | 55 | 33 | |||
111385 | 120459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988568.8662 | 2114996.16494 | 37.7867162951637 | -122.4833516722 | (37.7867162951637, -122.4833516722) | 11 | 6 | 1 | 55 | 33 | |||
57309 | 88585 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 811 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51528 | 5988482.92039 | 2110432.25241 | 37.7741800732451 | -122.483314341794 | (37.7741800732451, -122.483314341794) | 11 | 6 | 2 | 55 | 26 | ||
144781 | 120458 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988579.7702 | 2114992.84531 | 37.7867078149969 | -122.483313703981 | (37.7867078149969, -122.483313703981) | 11 | 6 | 1 | 55 | 33 | |||
96114 | 48895 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 161 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51493 | 5988654.05443 | 2114268.60686 | 37.7847235845666 | -122.483003600152 | (37.7847235845666, -122.483003600152) | 11 | 6 | 2 | 55 | 26 | |
104012 | 120317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 442 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988773.16818 | 2112284.8883 | 37.7792837822508 | -122.482446109308 | (37.7792837822508, -122.482446109308) | 11 | 6 | 2 | 55 | 26 | |||
133117 | 182033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1318 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988666.672 | 2106312.5286 | 37.7628791367764 | -122.482376807806 | (37.7628791367764, -122.482376807806) | 1 | 8 | 3 | 56 | 35 | |||
80313 | 68588 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1322 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32489 | 5988666.672 | 2106296.8366 | 37.7628360508154 | -122.482375658001 | (37.7628360508154, -122.482375658001) | 1 | 8 | 3 | 56 | 35 | ||
3143 | 46360 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2002 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.31969 | 37.7779021128043 | -122.482350384801 | (37.7779021128043, -122.482350384801) | 11 | 6 | 2 | 55 | 26 | |
190310 | 47269 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1463 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45210 | 5988654.8409 | 2105376.6422 | 37.7603087586576 | -122.482349152365 | (37.7603087586576, -122.482349152365) | 1 | 8 | 3 | 56 | 35 | |
78935 | 120488 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 6020 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988854.16632 | 2114030.55727 | 37.7840816098569 | -122.482293840378 | (37.7840816098569, -122.482293840378) | 11 | 6 | 2 | 55 | 26 | |||
55268 | 120447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988944.82314 | 2114949.71234 | 37.7866106225502 | -122.482047561852 | (37.7866106225502, -122.482047561852) | 11 | 6 | 1 | 55 | 33 | |||
182302 | 120446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988945.57573 | 2114940.19348 | 37.7865845302304 | -122.482044260519 | (37.7865845302304, -122.482044260519) | 11 | 6 | 1 | 55 | 33 | |||
77000 | 120445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988945.83143 | 2114929.73493 | 37.7865558288888 | -122.482042609422 | (37.7865558288888, -122.482042609422) | 11 | 6 | 1 | 55 | 33 | |||
99039 | 120444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.42808 | 2114912.85474 | 37.7865095153738 | -122.482039308131 | (37.7865095153738, -122.482039308131) | 11 | 6 | 1 | 55 | 33 | |||
104587 | 120443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.9866 | 2114882.90892 | 37.786427325124 | -122.482035181262 | (37.786427325124, -122.482035181262) | 11 | 6 | 1 | 55 | 33 | |||
149358 | 120442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988947.55811 | 2114864.8414 | 37.7863777500738 | -122.482031879947 | (37.7863777500738, -122.482031879947) | 11 | 6 | 1 | 55 | 33 |
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) );