Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 11829 | 11829 | 19801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14064 | 14064 | 19797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16189 | 16189 | 19840 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 145373 | 145373 | 118792 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 746 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5982002.3368 | 2110652.98782 | 37.7744068613492 | -122.505747814892 | (37.7744068613492, -122.505747814892) | ||||
| 56917 | 56917 | 250996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 453 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5982195.03644 | 2112765.4035099996 | 37.780218274692004 | -122.505237834779 | (37.780218274692, -122.505237834779) | |||
| 171910 | 171910 | 81988 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 442 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50000 | 5982237.66367 | 2112787.1570200003 | 37.780280511552206 | -122.505091982727 | (37.7802805115522, -122.505091982727) | |
| 44095 | 44095 | 47442 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 1 | Permit Number 45353 | 5982550.52878 | 2111435.68847 | 37.7765881781327 | -122.50390953033998 | (37.7765881781327, -122.50390953034) | |
| 131486 | 131486 | 37077 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1278 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 6 | Permit Number 39679 | 5982458.52457533 | 2106416.34966851 | 37.762801113898504 | -122.50385595731701 | (37.7628011138985, -122.503855957317) | |
| 45486 | 45486 | 40208 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 837 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 2 | Permit Number 41390 | 5982597.67837 | 2110065.0183099997 | 37.772827489399 | -122.503644899237 | (37.772827489399, -122.503644899237) | |
| 27013 | 27013 | 117880 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 614 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982902.29229 | 2111583.1189 | 37.777013657226796 | -122.502703613921 | (37.7770136572268, -122.502703613921) | |||
| 28472 | 28472 | 63001 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1223 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23409 | 5983019.7565 | 2106777.9999 | 37.7638270872907 | -122.50194164610599 | (37.7638270872907, -122.501941646106) | ||
| 166092 | 166092 | 183347 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1219 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983021.011 | 2106794.309 | 37.7638719411282 | -122.501938514072 | (37.7638719411282, -122.501938514072) | |||
| 37842 | 37842 | 82147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 861 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52672 | 5983843.06359 | 2109965.1090599997 | 37.772626310164796 | -122.499329652192 | (37.7726263101648, -122.499329652192) | |
| 68115 | 68115 | 117831 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983887.65647 | 2110080.17277 | 37.7729448580991 | -122.499183906831 | (37.7729448580991, -122.499183906831) | |||
| 33621 | 33621 | 102375 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983887.37527 | 2110050.4929400003 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | ||||
| 25448 | 25448 | 102374 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | ||||
| 39888 | 39888 | 102373 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983890.730690001 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | ||||
| 63117 | 63117 | 69043 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1411 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33050 | 5983994.9059 | 2105527.4427 | 37.7604506461086 | -122.498476575537 | (37.7604506461086, -122.498476575537) | |
| 55291 | 55291 | 91115 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 776 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52003 | 5984798.48875 | 2110573.10753 | 37.7743517064443 | -122.496069648958 | (37.7743517064443, -122.496069648958) | |
| 91604 | 91604 | 21229 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 111230 | 111230 | 21226 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 112355 | 112355 | 21227 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 108682 | 108682 | 111636 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486.0 | 2097347.0 | 37.738076708209796 | -122.492717127165 | (37.7380767082098, -122.492717127165) | ||
| 69600 | 69600 | 250770 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 247 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985863.4711 | 2114256.40781 | 37.7845273142332 | -122.492657058592 | (37.7845273142332, -122.492657058592) | |||
| 71699 | 71699 | 250844 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 242 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986530.96095 | 2114207.2735200003 | 37.784431412324295 | -122.490344186658 | (37.7844314123243, -122.490344186658) | |||
| 40003 | 40003 | 87230 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.760900766943294 | -122.489529520217 | (37.7609007669433, -122.489529520217) | ||
| 102256 | 102256 | 87231 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2575X JUDAH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.760900766943294 | -122.489529520217 | (37.7609007669433, -122.489529520217) | ||
| 50119 | 50119 | 120013 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 377 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5986822.04697 | 2113431.99077 | 37.7823197042456 | -122.489280120977 | (37.7823197042456, -122.489280120977) | |||
| 165333 | 165333 | 120012 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 379 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5986824.096940001 | 2113410.6730299997 | 37.7822612914883 | -122.489271461219 | (37.7822612914883, -122.489271461219) | |||
| 181404 | 181404 | 183736 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2267 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986978.4063 | 2099834.6763 | 37.7449943609019 | -122.48773991626899 | (37.7449943609019, -122.487739916269) | |||
| 1943 | 1943 | 116843 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2571 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987034.8 | 2097780.1 | 37.7393563293641 | -122.487394029182 | (37.7393563293641, -122.487394029182) | |
| 2175 | 2175 | 57807 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2571 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987052.3077 | 2097770.09 | 37.7393298655452 | -122.487332761031 | (37.7393298655452, -122.487332761031) | |
| 55446 | 55446 | 120059 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 126 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5987428.000469999 | 2115126.8571099997 | 37.7870086753365 | -122.48730834766 | (37.7870086753365, -122.48730834766) | |||
| 42661 | 42661 | 117099 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 358 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5987483.76011 | 2113562.21941 | 37.7827158788173 | -122.48700048333001 | (37.7827158788173, -122.48700048333) | |||
| 103526 | 103526 | 67956 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 823 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31675 | 5987552.59212802 | 2110344.39283654 | 37.7738846484949 | -122.486526019249 | (37.7738846484949, -122.486526019249) | ||
| 89363 | 89363 | 47211 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 6200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | ||
| 93278 | 93278 | 47210 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 6200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | ||
| 125475 | 125475 | 47212 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 6200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | ||
| 42616 | 42616 | 95927 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 593 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767624 | 5987807.15035 | 2111962.63313 | 37.7783427176202 | -122.48576426585 | (37.7783427176202, -122.48576426585) |
| 109366 | 109366 | 12852 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2425 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2001 12:00:00 AM | 6 | 3X3 | 5987893.29403 | 2114620.09876 | 37.785644384199 | -122.48566135129101 | (37.785644384199, -122.485661351291) | ||
| 163538 | 163538 | 182052 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1358 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987745.1727 | 2106038.1892 | 37.762072228870394 | -122.48554377889099 | (37.7620722288704, -122.485543778891) | |||
| 96983 | 96983 | 86916 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 28th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | ||
| 100049 | 100049 | 86915 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | ||
| 121380 | 121380 | 86914 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | ||
| 139110 | 139110 | 86913 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 49878 | 5987679.6 | 2099585.6 | 37.7443513377426 | -122.485297072409 | (37.7443513377426, -122.485297072409) | ||
| 157398 | 157398 | 181858 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1699 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987680.2773 | 2099613.4688 | 37.7444278975301 | -122.48529677501699 | (37.7444278975301, -122.485296775017) | |||
| 181001 | 181001 | 181859 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1689 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987694.8294 | 2099613.8072 | 37.7444296744268 | -122.48524648232402 | (37.7444296744268, -122.485246482324) | |||
| 89627 | 89627 | 84233 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 235 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52252 | 5988025.39868397 | 2114411.05493653 | 37.7850781058054 | -122.485188969204 | (37.7850781058054, -122.485188969204) | ||
| 48909 | 48909 | 181860 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1679 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987725.2874 | 2099613.8072 | 37.7444314487039 | -122.48514116618 | (37.7444314487039, -122.48514116618) | |||
| 51957 | 51957 | 34225 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 138 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52249 | 5988056.05348 | 2115056.1881 | 37.7868512432119 | -122.48513026546699 | (37.7868512432119, -122.485130265467) | |
| 54808 | 54808 | 84232 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 144 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52250 | 5988057.00135 | 2115013.9222 | 37.7867352483332 | -122.48512388383999 | (37.7867352483332, -122.48512388384) | |
| 70841 | 70841 | 84234 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | ||
| 68685 | 68685 | 181861 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1669 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987765.2212 | 2099616.5146 | 37.7444412086369 | -122.485003283678 | (37.7444412086369, -122.485003283678) | |||
| 58013 | 58013 | 32355 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 455 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 2 | Permit Number 36909 | 5988077.70341 | 2112909.74205 | 37.7809589730845 | -122.484897834483 | (37.7809589730845, -122.484897834483) | |
| 37727 | 37727 | 84237 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | ||
| 177740 | 177740 | 84252 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 525 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51823 | 5988096.43672 | 2112373.30059 | 37.7794871472518 | -122.48479366314699 | (37.7794871472518, -122.484793663147) | |
| 63425 | 63425 | 84240 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 559 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51827 | 5988105.14726 | 2112161.86234 | 37.778907104657 | -122.48474801526699 | (37.778907104657, -122.484748015267) | |
| 43704 | 43704 | 84247 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51829 | 5988106.91246 | 2112101.51452 | 37.7787415093277 | -122.484737480704 | (37.7787415093277, -122.484737480704) | |
| 73915 | 73915 | 84248 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 575 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52254 | 5988107.4199 | 2112077.58194 | 37.7786758267484 | -122.484733969212 | (37.7786758267484, -122.484733969212) | |
| 180756 | 180756 | 84246 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 583 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51830 | 5988110.57341 | 2112018.88919 | 37.7785148566216 | -122.48471875352301 | (37.7785148566216, -122.484718753523) | |
| 177546 | 177546 | 84255 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 591 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51832 | 5988111.36438 | 2111976.4189299997 | 37.7783982912941 | -122.484712901029 | (37.7783982912941, -122.484712901029) | |
| 79735 | 79735 | 88396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.3051849995 | 2111648.444046 | 37.777498983924204 | -122.484616395841 | (37.7774989839242, -122.484616395841) | |||
| 50912 | 50912 | 84256 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 530 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51824 | 5988154.66782 | 2112350.19785 | 37.779427104906794 | -122.484590524432 | (37.7794271049068, -122.484590524432) | |
| 148884 | 148884 | 84245 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 546 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51825 | 5988156.49363 | 2112255.06762 | 37.7791660104002 | -122.484577228457 | (37.7791660104002, -122.484577228457) | |
| 118177 | 118177 | 56487 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 554 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51826 | 5988158.72366 | 2112206.88577 | 37.7790338464631 | -122.48456597884399 | (37.7790338464631, -122.484565978844) | |
| 67022 | 67022 | 84243 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 570 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51828 | 5988163.02484 | 2112103.0175799998 | 37.778748904105 | -122.48454347876101 | (37.778748904105, -122.484543478761) | |
| 55748 | 55748 | 120211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 586 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5988168.83389 | 2111986.60487 | 37.778429605809606 | -122.48451484226001 | (37.7784296058096, -122.48451484226) | |||
| 166689 | 166689 | 84250 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 598 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51831 | 5988169.58035 | 2111959.06238 | 37.7783540253404 | -122.48451023928101 | (37.7783540253404, -122.484510239281) | |
| 52413 | 52413 | 84261 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 751 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51837 | 5988150.92473 | 2110870.15339 | 37.7753631000589 | -122.484494885291 | (37.7753631000589, -122.484494885291) | |
| 177559 | 177559 | 89206 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 751 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51837 | 5988151.592569999 | 2110851.24379 | 37.7753112184725 | -122.484491187824 | (37.7753112184725, -122.484491187824) | |
| 59749 | 59749 | 84260 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 660 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988186.45102 | 2111472.04935 | 37.777017806636 | -122.484416148832 | (37.777017806636, -122.484416148832) | ||
| 129092 | 129092 | 89205 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51833 | 5988199.0 | 2111465.2 | 37.7769997309607 | -122.48437223607999 | (37.7769997309607, -122.48437223608) | |||
| 118712 | 118712 | 84259 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51834 | 5988199.0 | 2111465.0 | 37.7769991818167 | -122.48437222140801 | (37.7769991818167, -122.484372221408) | |
| 81714 | 81714 | 84264 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 706 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51836 | 5988196.19681756 | 2111153.20352169 | 37.7761429127735 | -122.48435904478998 | (37.7761429127735, -122.48435904479) | ||
| 71299 | 71299 | 84271 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 849 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51840 | 5988175.82653 | 2110179.2718700003 | 37.7734675822134 | -122.484358062894 | (37.7734675822134, -122.484358062894) | |
| 41901 | 41901 | 84268 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 839 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51839 | 5988177.458869999 | 2110243.6425099997 | 37.773644421108706 | -122.484357138502 | (37.7736444211087, -122.484357138502) | |
| 83732 | 83732 | 84236 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52255 | 5988243.61998404 | 2113329.74294271 | 37.7821218391843 | -122.48435466732401 | (37.7821218391843, -122.484354667324) | ||
| 158376 | 158376 | 84265 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 766 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51838 | 5988211.57973 | 2110760.94894 | 37.775066787042206 | -122.484277057304 | (37.7750667870422, -122.484277057304) | |
| 151524 | 151524 | 182716 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1707 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988092.0603 | 2103661.619 | 37.7555670168906 | -122.484169748346 | (37.7555670168906, -122.484169748346) | |||
| 154564 | 154564 | 84272 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 882 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51842 | 5988237.3658300005 | 2109972.3382599996 | 37.7729029832415 | -122.484130013867 | (37.7729029832415, -122.484130013867) | |
| 148642 | 148642 | 84257 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.48410321533899 | (37.7727438112406, -122.484103215339) | ||
| 26851 | 26851 | 49941 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2474@ ULLOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 1 | Permit Number 46699 | 5988007.7004 | 2098472.4797 | 37.741314111571796 | -122.48408097239401 | (37.7413141115718, -122.484080972394) | |
| 36189 | 36189 | 120471 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 88 West Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988434.04491 | 2115070.90864 | 37.7869136727274 | -122.483823598526 | (37.7869136727274, -122.483823598526) | |||
| 71418 | 71418 | 120472 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 88 West Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988447.19453 | 2115067.03638 | 37.786903806069 | -122.483777820382 | (37.786903806069, -122.483777820382) | |||
| 76471 | 76471 | 120473 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 88 West Clay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5988459.1629 | 2115064.1874700002 | 37.7868966804599 | -122.483736204114 | (37.7868966804599, -122.483736204114) | |||
| 27480 | 27480 | 120474 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 88 West Clay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5988469.711569999 | 2115060.56996 | 37.78688736184021 | -122.483699443255 | (37.7868873618402, -122.483699443255) | |||
| 178936 | 178936 | 120460 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 67 West Clay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988559.61165 | 2114998.49915 | 37.7867221656327 | -122.483383861528 | (37.7867221656327, -122.483383861528) | |||
| 33326 | 33326 | 120459 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 67 West Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5988568.8662 | 2114996.16494 | 37.7867162951637 | -122.48335167219999 | (37.7867162951637, -122.4833516722) | |||
| 69763 | 69763 | 88585 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 811 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51528 | 5988482.920390001 | 2110432.2524099997 | 37.7741800732451 | -122.483314341794 | (37.7741800732451, -122.483314341794) | ||
| 182666 | 182666 | 120458 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 67 West Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5988579.7702 | 2114992.84531 | 37.7867078149969 | -122.483313703981 | (37.7867078149969, -122.483313703981) | |||
| 45468 | 45468 | 48895 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 161 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51493 | 5988654.0544300005 | 2114268.6068599997 | 37.7847235845666 | -122.483003600152 | (37.7847235845666, -122.483003600152) | |
| 61479 | 61479 | 120317 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 442 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988773.16818 | 2112284.8883 | 37.77928378225079 | -122.482446109308 | (37.7792837822508, -122.482446109308) | |||
| 133315 | 133315 | 182033 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1318 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988666.672 | 2106312.5286 | 37.7628791367764 | -122.48237680780599 | (37.7628791367764, -122.482376807806) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");