trees

3,247 rows where qSpecies_id = 22 sorted by DBH

✎ View and edit SQL

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)
34230 85315 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 668 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2007 12:00:00 AM     Permit Number 49595 6002374 2104313 37.7581767429847 -122.434824993161 (37.7581767429847, -122.434824993161) 2 4 5 28862 3
34519 64597 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3376 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1988 12:00:00 AM     Permit Number 25498 6005858.20323886 2103182.11056337 37.7552687846383 -122.422694728513 (37.7552687846383, -122.422694728513) 2 4 5 28859 19
35002 98799 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
35203 33014 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3625 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37305 6005620.98142938 2101949.23575785 37.7518702093111 -122.423427471135 (37.7518702093111, -122.423427471135) 2 4 5 28859 19
35251 94289 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 901 Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2009 12:00:00 AM   3x3 Permit Number 52965 6009147 2103917 37.7574716284078 -122.411372960691 (37.7574716284078, -122.411372960691) 2 4 7 28859 19
35371 91453 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 680 WASHINGTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2009 12:00:00 AM   3x3 Permit Number 52103 6011317 2117738 37.7955423680345 -122.404841229346 (37.7955423680345, -122.404841229346) 3 1 10 28857 4
35642 98967 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 302x Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
35704 91458 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 808 Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2009 12:00:00 AM   3x3 Permit Number 52103 6011295 2117692 37.7954148333998 -122.404914113244 (37.7954148333998, -122.404914113244) 3 1 10 28857 4
36124 49342 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Clifford Ter 5 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2003 12:00:00 AM     Permit Number 46332 5999646.98705896 2106515.41862964 37.7640688343052 -122.444414431135 (37.7640688343052, -122.444414431135) 15 5 5 29492 9
36427 98965 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 302x Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
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
36687 91316 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 450 Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2009 12:00:00 AM   3x3 Permit Number 52049 6011745 2106547 37.7648383947947 -122.40257292402 (37.7648383947947, -122.40257292402) 8 3 8 28853 20
36702 44350 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 50 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2001 12:00:00 AM     Permit Number 43730 6001421.82068247 2107945.22005196 37.7680958224652 -122.438378257061 (37.7680958224652, -122.438378257061) 15 5 5 29492 3
37074 101250 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 737 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993514 2106614 37.7639876770853 -122.465633627671 (37.7639876770853, -122.465633627671) 1 8 11 56 12
37510 30602 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 140 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM     Permit Number 34568 6007766.12041799 2109892.83524287 37.7738023323227 -122.416571913724 (37.7738023323227, -122.416571913724) 8 2 9 28853 19
37647 44195 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
37981 104106 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 9 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
38267 67385 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 600 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1992 12:00:00 AM     Permit Number 30881 5992563.12604508 2111350.67725686 37.776938433872 -122.469267171865 (37.776938433872, -122.469267171865) 11 6 2 54 11
38441 104099 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 2 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
39201 48395 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 72 Mars St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45777 5999572.80170185 2105370.51265234 37.7609209742541 -122.444588722127 (37.7609209742541, -122.444588722127) 15 5 5 28862 3
39546 104103 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 6 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
40150 93868 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 4045 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2010 12:00:00 AM   3x3 Permit Number 53365 6002857 2102387 37.7529158168882 -122.433016969095 (37.7529158168882, -122.433016969095) 2 4 5 28862 22
40476 85221 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1414 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2           6011703 2101780 37.7517469232523 -122.40238298191 (37.7517469232523, -122.40238298191) 10 3 8 28856 29
41278 66312 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 143 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29427 6001377.41574875 2095374.46813255 37.7335770202313 -122.437631471673 (37.7335770202313, -122.437631471673) 9 7 5 63 40
41338 109613 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 311x DAVIS ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013158 2117662 37.7954364211004 -122.398465672767 (37.7954364211004, -122.398465672767) 3 1 10 28860 6
41624 50587 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 843 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2008 12:00:00 AM   3x3 Permit Number 50206 6007574.72347532 2104752.94672334 37.7596786357422 -122.416869761057 (37.7596786357422, -122.416869761057) 2 4 7 28859 19
42158 43568 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 601 29TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
42164 44189 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
42409 91313 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 450 Rhode Island St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2009 12:00:00 AM   3x3 Permit Number 52049 6011745 2106547 37.7648383947947 -122.40257292402 (37.7648383947947, -122.40257292402) 8 3 8 28853 20
42425 37323 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 465 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39836 6003319.75877795 2103865.74575839 37.7570023398617 -122.431522222437 (37.7570023398617, -122.431522222437) 2 4 5 28862 3
42924 36915 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 514 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/27/1998 12:00:00 AM     Permit Number 39561 6001810.86453824 2102841.54122149 37.7541044834193 -122.43666722972 (37.7541044834193, -122.43666722972) 2 4 5 28862 22
43066 57165 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2616 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42848 6003634.5143762 2117314.3321902 37.7939466747915 -122.431393686963 (37.7939466747915, -122.431393686963) 13 9 1 29490 27
43130 48464 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1900only Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2005 12:00:00 AM     Permit Number 45826 6001339.4267527 2112520.04944092 37.7806524690374 -122.438991149316 (37.7806524690374, -122.438991149316) 15 5 11 29490 41
43709 63415 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 278 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 23998 6001429.88159377 2104210.13980699 37.757840666022 -122.438082788745 (37.757840666022, -122.438082788745) 2 4 5 28862 3
43719 68440 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 754 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2007 12:00:00 AM   3x3 Permit Number 49886 5993219.88276902 2113506.20153873 37.782894848692 -122.467152027766 (37.782894848692, -122.467152027766) 11 6 2 54 11
44799 84752 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 170 King St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2007 12:00:00 AM     Permit No. 49304 6014851 2111791 37.7794101710037 -122.392196759897 (37.7794101710037, -122.392196759897) 6 2 9 28856 6
44959 44241 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 317 Harriet St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM     Permit Number 43677 6011781.7513621 2110406.95147967 37.7754389967998 -122.402717284978 (37.7754389967998, -122.402717284978) 14 2 9 28853 34
45608 40433 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 101 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1999 12:00:00 AM     Permit Number 41526 6007627.96125429 2098166.4451197 37.7415965860949 -122.416219146331 (37.7415965860949, -122.416219146331) 2 7 7 28859 2
45818 254999 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x6   6001381 2091997 37.7243034696348 -122.437377313626 (37.7243034696348, -122.437377313626) 9 7 6 28861 25
46077 67375 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 925 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1992 12:00:00 AM     Permit Number 30870 5992766.01724048 2111352.45754002 37.7769550441549 -122.468565444785 (37.7769550441549, -122.468565444785) 11 6 2 54 11
46097 51658 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 965 @ PARIS Geneva Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47940 6000578.12419421 2089000.08275614 37.7160289372019 -122.439937951405 (37.7160289372019, -122.439937951405) 9 7 6 28861 5
46282 110937 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 98x WILMOT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003200 2115008 37.7875894402279 -122.432732318133 (37.7875894402279, -122.432732318133) 13 9 11 29490 27
46474 30729 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 45 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
47051 109519 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 4801X 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999644.57626 2104777.09851 37.7592957011711 -122.444297841065 (37.7592957011711, -122.444297841065) 2 4 5 28862 3
47544 46348 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1507 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2002 12:00:00 AM     Permit Number 44593 6002034.30683113 2099698.46160484 37.7454870285073 -122.435669660946 (37.7454870285073, -122.435669660946) 2 7 5 63 22
48021 46347 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1507 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2002 12:00:00 AM     Permit Number 44593 6002034.30683113 2099698.46160484 37.7454870285073 -122.435669660946 (37.7454870285073, -122.435669660946) 2 7 5 63 22
48158 84950 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1305 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49351 6009354 2101579 37.7510636126747 -122.410491979069 (37.7510636126747, -122.410491979069) 2 4 7 28859 19
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
48498 33757 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 16 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM     Permit Number 37810 6003402.50922955 2107448.70310464 37.766844969098 -122.431491817447 (37.766844969098, -122.431491817447) 15 5 5 28862 3
48619 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 78 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
48860 31103 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 420 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34833 5999457.19750616 2094476.41110403 37.7310017996631 -122.444205686044 (37.7310017996631, -122.444205686044) 9 7 4 63 40
49194 51243 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 225 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47614 6002729.5142097 2104585.32295254 37.7589446544165 -122.433614934398 (37.7589446544165, -122.433614934398) 2 4 5 28862 3
50055 44778 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 938 Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43877 6011792.18948294 2111489.0452941 37.7784107598375 -122.402757294311 (37.7784107598375, -122.402757294311) 14 2 9 28856 34
51175 64626 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 116 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1988 12:00:00 AM     Permit Number 25535 6005375.93887889 2103023.58522731 37.7548062901099 -122.424351269312 (37.7548062901099, -122.424351269312) 2 4 5 28859 19
51300 50589 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 843 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2008 12:00:00 AM   3x3 Permit Number 50206 6007574.72347532 2104752.94672334 37.7596786357422 -122.416869761057 (37.7596786357422, -122.416869761057) 2 4 7 28859 19
51358 256597 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 24 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
51369 44194 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
51429 50226 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1200 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50896 5994559.80956371 2107356.04846138 37.7660854146632 -122.462070325428 (37.7660854146632, -122.462070325428) 11 5 11 56 12
52190 98423 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1501X Steiner St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.434425094313 (37.7831064505465, -122.434425094313) 13 9 11 29490 41
52369 50151 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 215 REVISED Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2003 12:00:00 AM     Permit Number 46870 6014159.85874387 2115328.34387959 37.7890845068427 -122.3948355307 (37.7890845068427, -122.3948355307) 6 2 9 28855 6
53229 64416 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 18 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM   3x3 Permit Number 50677 6003642.17980217 2098229.65792649 37.7415452293262 -122.430005134049 (37.7415452293262, -122.430005134049) 2 7 5 63 7
53394 48939 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1217 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51559 6011656.22941119 2091520.4365034 37.7235737218991 -122.401823619835 (37.7235737218991, -122.401823619835) 10 3 7 309 28
53804 36958 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 22 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39588 5994276.09301697 2115432.47686212 37.788244789102 -122.46363785633 (37.788244789102, -122.46363785633) 11 6 1 54 11
53861 94288 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 901 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2009 12:00:00 AM   3x3 Permit Number 52965 6009147 2103917 37.7574716284078 -122.411372960691 (37.7574716284078, -122.411372960691) 2 4 7 28859 19
54066 45340 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1335 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2001 12:00:00 AM     Permit Number 44170 6006996.02252299 2107706.14751942 37.767754866633 -122.419080678059 (37.767754866633, -122.419080678059) 8 4 7 28853 19
54396 63399 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 169 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/11/1987 12:00:00 AM     Permit Number 23981 6001446.51637596 2104852.85436771 37.7596063500713 -122.43807129721 (37.7596063500713, -122.43807129721) 2 4 5 28862 3
54607 108196 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 930 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
54657 60664 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 249 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20298 6004405.0967778 2096932.39684696 37.7380264232829 -122.427274839887 (37.7380264232829, -122.427274839887) 2 7 5 63 7
54877 63413 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 272 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 23996 6001428.0278078 2104243.75473301 37.7579328590275 -122.438091607798 (37.7579328590275, -122.438091607798) 2 4 5 28862 3
54935 64594 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3351 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1992 12:00:00 AM     Permit Number 31334 6006004.81140663 2103137.43294391 37.7551543807062 -122.422184539111 (37.7551543807062, -122.422184539111) 2 4 5 28859 19
55376 91312 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 450 Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2009 12:00:00 AM   3x3 Permit Number 52049 6011745 2106547 37.7648383947947 -122.40257292402 (37.7648383947947, -122.40257292402) 8 3 8 28853 20
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
56469 33751 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 845 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38932 6005705.24449579 2104057.07564242 37.7576626039009 -122.42328590054 (37.7576626039009, -122.42328590054) 2 4 5 28859 19
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
56661 65808 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2300 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28776 5991285.24152373 2099744.65687546 37.7449974586831 -122.472841240296 (37.7449974586831, -122.472841240296) 1 8 4 29491 40
57007 48370 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 350& 17th ST Rhode Island St 23 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM     Permit Number 45774 6011708.83412888 2106755.94348957 37.7654100874921 -122.402712708416 (37.7654100874921, -122.402712708416) 8 3 8 28853 20
57202 109123 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
58917 31098 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 106 Baden St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM   3x3 Permit Number 34828 6000773.52308358 2094378.43446276 37.7308077879844 -122.439647916066 (37.7308077879844, -122.439647916066) 9 7 4 63 40
59102 30726 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 45 Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
59735 87449 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2022 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2008 12:00:00 AM   3x3 Permit Number 50375 5992651.8 2101666.3 37.7503528147197 -122.468255737693 (37.7503528147197, -122.468255737693) 1 8 4 29491 12
59926 57382 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3649 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/2006 12:00:00 AM     Permit Number 16220 6006004.10148285 2101384.24745551 37.7503404974412 -122.422062453278 (37.7503404974412, -122.422062453278) 2 4 5 28859 19
60243 31550 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 750 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1995 12:00:00 AM     Permit Number 35098 5996892.54866938 2112464.99439626 37.7802472834162 -122.454370968086 (37.7802472834162, -122.454370968086) 11 6 2 54 16
60647 37865 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 544 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/1998 12:00:00 AM     Permit Number 40152 6002805.0215525 2103304.96287726 37.7554333760991 -122.433262307406 (37.7554333760991, -122.433262307406) 2 4 5 28862 22
60757 51338 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2345 Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2004 12:00:00 AM     Permit Number 47687 5998288.77869718 2111348.12240087 37.7772606157071 -122.449460290108 (37.7772606157071, -122.449460290108) 15 6 2 29492 16
60902 65916 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1261 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28926 5994522.99651217 2106913.70637586 37.7648687391536 -122.462165570632 (37.7648687391536, -122.462165570632) 11 5 11 56 12
61650 35468 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 430 Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38886 6007237.08907724 2112375.34283194 37.7805889355944 -122.418577996505 (37.7805889355944, -122.418577996505) 7 9 9 28852 36
61826 67724 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1346 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31342 5992116.05706304 2106274.73338322 37.7629754095582 -122.470443943147 (37.7629754095582, -122.470443943147) 1 8 11 56 12
61947 36689 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 30 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM     Permit Number 45855 6005757.61033958 2107079.95878875 37.7659656844986 -122.423319681918 (37.7659656844986, -122.423319681918) 8 4 5 28853 19
62867 49464 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1598REVISED Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2004 12:00:00 AM     Permit Number 46392 6005257.3535793 2099024.34927744 37.7438186126757 -122.424476921386 (37.7438186126757, -122.424476921386) 2 7 5 63 22
63093 64585 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3370 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1991 12:00:00 AM     Permit Number 25485 6005892.95965728 2103183.86212541 37.7552755548974 -122.422574654764 (37.7552755548974, -122.422574654764) 2 4 5 28859 19
63179 48949 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2948 20TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52657 6009480 2104566 37.7592723071393 -122.410267130248 (37.7592723071393, -122.410267130248) 2 4 7 28859 19
63259 55483 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 541 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/1972 12:00:00 AM     Permit Number 11436 6002127.49962023 2110317.53066038 37.774649712906 -122.436107174272 (37.774649712906, -122.436107174272) 15 5 11 29492 10
64248 33752 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 845 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38932 6005705.24449579 2104057.07564242 37.7576626039009 -122.42328590054 (37.7576626039009, -122.42328590054) 2 4 5 28859 19
64326 68228 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 737 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32022 5993512.24196294 2106616.67074955 37.7639949088607 -122.465639902196 (37.7639949088607, -122.465639902196) 1 8 11 56 12
64356 63006 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 171 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1986 12:00:00 AM     Permit Number 23419 6007602.6132672 2097873.37773312 37.7407904626696 -122.416286039061 (37.7407904626696, -122.416286039061) 2 7 7 28859 2
64363 69102 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1680 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33117 5992503.87286024 2104024.86797195 37.7568202857156 -122.468938895378 (37.7568202857156, -122.468938895378) 1 8 4 56 12
64409 41553 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1232 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2000 12:00:00 AM     Permit Number 42076 6003836.12628795 2101097.03674295 37.7494293696774 -122.429538977947 (37.7494293696774, -122.429538977947) 2 4 5 28862 22
64504 63810 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 401 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24497 6008811.16610479 2096905.91798547 37.7382019141456 -122.412038948556 (37.7382019141456, -122.412038948556) 10 7 7 28859 2
64670 63829 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 621 Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24517 6008649.4472007 2096960.49920936 37.7383427074013 -122.412601951556 (37.7383427074013, -122.412601951556) 10 7 7 28859 2
65305 33441 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 220 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/1996 12:00:00 AM     Permit Number 37543 6006379.64079158 2098541.7631108 37.7425568534401 -122.420562059553 (37.7425568534401, -122.420562059553) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);