39,840 rows where qLegalStatus_id = 7 sorted by Police Districts descending

View and edit SQL

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)
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
340 42995 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42871 6004515.16540478 2110012.02065503 37.7739462176361 -122.42782598565 (37.7739462176361, -122.42782598565) 7 9 11 28852 10
376 33627 Permitted Site 7 Tree(s) :: 17 315 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1996 12:00:00 AM     Permit Number 37728 6005028.27785393 2110030.93274628 37.7740271589488 -122.426052389372 (37.7740271589488, -122.426052389372) 7 9 11 28852 10
414 8435 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1730 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1997 12:00:00 AM 13 3X3   6003010.73492 2113853.74303 37.784409407274 -122.433304626878 (37.784409407274, -122.433304626878) 13 9 11 29490 13
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
633 9792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
1045 17359 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2221X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005488.40666 2117587.01663 37.7948002909451 -122.424998441372 (37.7948002909451, -122.424998441372) 13 9 1 28858 27
1143 29069 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1002X Laguna St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 15 3x3   6004818.3149515 2112301.2204093 37.7802489436872 -122.4269404119 (37.7802489436872, -122.4269404119) 7 9 11 28852 41
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
1308 52427 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1815X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 5 3x3 Permit Number 48544 6004786.32091155 2115731.58720361 37.7896660673411 -122.427295522794 (37.7896660673411, -122.427295522794) 13 9 11 28858 27
1405 96265 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM     Permit Number 767311 6004841.3 2119075.5 37.798850712467 -122.427343605274 (37.798850712467, -122.427343605274) 13 9 1 57 17
1518 99500 Permitted Site 7 Aesculus hippocastanum :: White Horsechestnut 190 2698@Divisadero Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000656 2117555 37.7944382299983 -122.441716891944 (37.7944382299983, -122.441716891944) 13 9 1 57 27
1627 35149 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 11 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1998 12:00:00 AM     Permit Number 38681 6004664.75137838 2109286.2995173 37.7719620248453 -122.427256837171 (37.7719620248453, -122.427256837171) 7 9 11 28852 10
1748 56640 Permitted Site 7 Tree(s) :: 17 2016 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2           6004277.89575757 2115357.17634953 37.7886092629589 -122.429027916831 (37.7886092629589, -122.429027916831) 13 9 11 29490 27
1900 141936 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1101 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   10/12/1994 12:00:00 AM 8 Width 0ft   6003954.1428 2112136.7195 37.7797483635991 -122.429918243479 (37.7797483635991, -122.429918243479) 7 9 11 29490 41
2222 20236 Permitted Site 7 Maytenus boaria :: Mayten 58 1750X Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1992 12:00:00 AM 6 4X4   6002603.6550052 2114233.7432168 37.7854296891778 -122.434740163706 (37.7854296891778, -122.434740163706) 13 9 11 29490 13
2251 143510 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003323.1573 2118630.9053 37.797543994409 -122.432565097779 (37.797543994409, -122.432565097779) 13 9 1 57 17
2294 84947 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
2426 100409 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
2484 20118 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 875X Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/1992 12:00:00 AM 12 2X2   6003233.15229 2110304.12624 37.774675660821 -122.432281545934 (37.774675660821, -122.432281545934) 15 9 11 29492 10
2546 23472 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2356 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3 Permit Number 782620 6005919.56056 2118542.30149 37.7974476069742 -122.423574537547 (37.7974476069742, -122.423574537547) 13 9 10 28858 32
2630 47383 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1515 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2003 12:00:00 AM     Permit Number 46367 6006307.07862293 2118296.63950756 37.7967949468883 -122.422216159163 (37.7967949468883, -122.422216159163) 13 9 10 28858 32
2714 113322 Permitted Site 7 Olea europaea :: Olive Tree 9 100 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709) 7 9 5 28862 3
2751 32002 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2652 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1995 12:00:00 AM   5x5 Permit Number 35399 6000302.11365106 2118206.59769697 37.7962071755692 -122.442988194102 (37.7962071755692, -122.442988194102) 13 9 1 57 17
2856 64671 Permitted Site 7 Tree(s) :: 17 825 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/1988 12:00:00 AM     Permit Number 25617 6006551.01917293 2113304.1780681 37.7831006421796 -122.421017411704 (37.7831006421796, -122.421017411704) 7 9 11 28858 41
2884 46077 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 814 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2001 12:00:00 AM     Permit Number 44458 6003949.63841524 2110800.90118746 37.7760802817088 -122.429838518249 (37.7760802817088, -122.429838518249) 7 9 11 29492 10
2977 32167 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 434 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35509 6004474.73230352 2109832.86168631 37.773452003453 -122.427953081401 (37.773452003453, -122.427953081401) 7 9 11 28852 10
3080 42712 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 1451 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42724 6006618.85507529 2118340.07511889 37.7969317909654 -122.4211404244 (37.7969317909654, -122.4211404244) 13 9 10 28858 32
3240 23833 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 3 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
3654 47498 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
3691 121048 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2652 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6006192.78395747 2119877.54417008 37.8011292630692 -122.422724050002 (37.8011292630692, -122.422724050002) 13 9 1 28858 32
3857 104292 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2245 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999485.4 2120797.2 37.8032736772553 -122.446000602494 (37.8032736772553, -122.446000602494) 13 9 1 57 17
3941 92078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1151 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083 2115004 37.7877979108835 -122.419297592258 (37.7877979108835, -122.419297592258) 13 9 10 28858 21
4011 62663 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 210 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/2003 12:00:00 AM     Permit Number 30678 6003703.58181069 2109204.83752166 37.7716839461227 -122.43057577962 (37.7716839461227, -122.43057577962) 15 9 11 29492 10
4131 38411 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
4428 66790 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2150 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2010 12:00:00 AM   3x3 Permit Number 53367 6006860.21214417 2118575.27175394 37.79759118503 -122.420321971868 (37.79759118503, -122.420321971868) 5 9 10 28858 32
4656 61810 Permitted Site 7 Maytenus boaria :: Mayten 58 473 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21840 6003450.97814623 2108943.61336851 37.7709523752315 -122.431430899679 (37.7709523752315, -122.431430899679) 15 9 11 29492 10
4658 46466 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3310X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM 12 3x3 Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
4712 39418 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401Bldg #8 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40928 6004636.26366245 2109802.84186708 37.773378713416 -122.427392181999 (37.773378713416, -122.427392181999) 7 9 11 28852 10
4721 44169 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2100 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM     Permit Number 43638 6003503.99505303 2117958.62597334 37.795708342081 -122.431891323133 (37.795708342081, -122.431891323133) 13 9 1 57 17
4903 88595 Permitted Site 7 Olea europaea :: Olive Tree 9 399 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52536 6004228 2109402 37.7722550008378 -122.428775842479 (37.7722550008378, -122.428775842479) 7 9 11 28852 10
5117 244203 Permitted Site 7 Myoporum laetum :: Myoporum 62 539 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM 11 Width 0ft Permit Number 775931 6004029.0238 2109765.535 37.7732419154682 -122.429490048832 (37.7732419154682, -122.429490048832) 7 9 11 29492 10
5178 53028 Permitted Site 7 Tree(s) :: 17 2709@ UNION Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/06/2006 12:00:00 AM     Permit Number 49007 5999568.7122913 2118115.36126644 37.7959148228215 -122.445519339313 (37.7959148228215, -122.445519339313) 13 9 1 57 17
5262 63631 Permitted Site 7 Tree(s) :: 17 3011 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1987 12:00:00 AM     Permit Number 24274 6001965.52820466 2118455.53354324 37.7969853865901 -122.437250284017 (37.7969853865901, -122.437250284017) 13 9 1 57 17
5589 39428 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 290 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM   3x3 Permit Number 40930 6004202.2780492 2109746.86965534 37.7732004728874 -122.428889408135 (37.7732004728874, -122.428889408135) 7 9 11 28852 10
5664 50654 Permitted Site 7 Tree(s) :: 17 2824 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2003 12:00:00 AM     Permit Number 47236 6004394.14845271 2118840.16150037 37.7981792344265 -122.428874109151 (37.7981792344265, -122.428874109151) 13 9 1 57 17
5822 16933 Permitted Site 7 Ficus nitida :: Laurel Fig 53 530 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2     24 3X3   6004214.00427 2110149.16937 37.7743057532085 -122.428877532014 (37.7743057532085, -122.428877532014) 7 9 11 28852 10
5842 52901 Permitted Site 7 Tree(s) :: 17 2460 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2006 12:00:00 AM     Permit Number 48895 5999270.65065072 2117331.25061337 37.7937448428959 -122.446494245637 (37.7937448428959, -122.446494245637) 13 9 1 57 27
5900 14792 Permitted Site 7 Rhaphiolepis indica :: India Hawthorn 293 1077 McAllister St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1997 12:00:00 AM 6 4X4   6004038.31085 2111808.31104 37.7788514015092 -122.429603641013 (37.7788514015092, -122.429603641013) 7 9 11 29490 41
5931 7196 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 949 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003418.39077 2111568.89089 37.7781588927529 -122.431731089816 (37.7781588927529, -122.431731089816) 15 9 11 29492 41
6143 41891 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 401 Duboce Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2000 12:00:00 AM     Permit Number 42259 6004099.97108515 2108358.83625404 37.7693834800973 -122.429144312501 (37.7693834800973, -122.429144312501) 7 9 5 28862 3
6159 61799 Permitted Site 7 Tree(s) :: 17 150 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1985 12:00:00 AM     Permit Number 21825 6003367 2108901.1 37.7708308840658 -122.431718346405 (37.7708308840658, -122.431718346405) 15 9 11 29492 10
6160 42787 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 413 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM   3x3 Permit Number 42754 6004586.33786017 2109969.42501453 37.7738332863504 -122.427576752843 (37.7738332863504, -122.427576752843) 7 9 11 28852 10
6180 33653 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 284 Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37742 6006036.93235026 2110918.36759919 37.776520795938 -122.422626351394 (37.776520795938, -122.422626351394) 7 9 11 28852 10
6315 46517 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 182 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2003 12:00:00 AM     Permit Number 46010 6005209.24135079 2109497.7250609 37.7725733258296 -122.425388452589 (37.7725733258296, -122.425388452589) 7 9 11 28852 10
6344 33663 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 424 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37751 6005309.8782552 2111164.52643651 37.7771556428857 -122.425158961888 (37.7771556428857, -122.425158961888) 7 9 11 28852 10
6608 47030 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
6672 39412 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401Bldg #8 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40928 6004636.26366245 2109802.84186708 37.773378713416 -122.427392181999 (37.773378713416, -122.427392181999) 7 9 11 28852 10
6688 119707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree Private 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
6748 57527 Permitted Site 7 Tree(s) :: 17 700 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/1976 12:00:00 AM     Permit Number 16386 6004962.9591132 2111265.64001346 37.7774136719189 -122.426366266738 (37.7774136719189, -122.426366266738) 7 9 11 28852 10
6818 102380 Permitted Site 7 Tree(s) :: 17 2050 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2013 12:00:00 AM 14 3x3 Permit Number 771000 6001969 2119823 37.8007402883162 -122.437336238425 (37.8007402883162, -122.437336238425) 13 9 1 57 17
6869 51982 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 660 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2005 12:00:00 AM     Permit Number 48204 6007266.85815782 2113345.5415055 37.7832545419232 -122.4185438282 (37.7832545419232, -122.4185438282) 7 9 9 28858 36
7104 9470 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 800X Golden Gate Ave 26 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.7806668426278 -122.423843265886 (37.7806668426278, -122.423843265886) 7 9 11 28852 41
7135 31599 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1545 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1995 12:00:00 AM     Permit Number 35125 6005790.56016394 2115408.85465363 37.7888366668164 -122.423797994836 (37.7888366668164, -122.423797994836) 13 9 1 28858 41
7255 14729 Permitted Site 7 Maytenus boaria :: Mayten 58 880 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
7377 14771 Permitted Site 7 Schinus terebinthifolius :: Brazilian Pepper 93 1000X McAllister St 6 Sidewalk: Curb side : Cutout Tree Office of Mayor 9     18 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
7432 40564 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 223 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/2004 12:00:00 AM     Permit Number 41608 6003273.4207217 2109055.89818285 37.7712506170222 -122.432053094849 (37.7712506170222, -122.432053094849) 15 9 11 29492 9
7488 21658 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1745 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004251.7833336 2114607.9002324 37.7865504610901 -122.42906481766 (37.7865504610901, -122.42906481766) 13 9 11 29490 13
7523 254506 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1928 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/22/2018 12:00:00 AM 3 3x3   6004702.10653 2115410.06007 37.7887784716518 -122.427563979846 (37.7887784716518, -122.427563979846) 13 9 11 28858 27
7530 27369 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 251 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006819.3487219 2111354.6736121 37.7777628978385 -122.419950711926 (37.7777628978385, -122.419950711926) 7 9 11 28852 10
7541 54875 Permitted Site 7 Maytenus boaria :: Mayten 58 300 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/24/2004 12:00:00 AM     Permit Number 25697 6005109.34291576 2109921.18465674 37.7737303986235 -122.425764158103 (37.7737303986235, -122.425764158103) 7 9 11 28852 10
7597 9777 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 897X Gough St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6005678.151576 2112736.5747486 37.7814929008439 -122.42399680549 (37.7814929008439, -122.42399680549) 7 9 11 28852 41
7649 39891 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1550 Sutter St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM     Permit Number 41175 6005174.09555111 2114787.61295618 37.7870960726836 -122.425886638993 (37.7870960726836, -122.425886638993) 13 9 11 28858 27
7664 261543 Permitted Site 7 :: 45 1305 Lombard St 2 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 20x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
7885 57193 Permitted Site 7 Tree(s) :: 17 633 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1974 12:00:00 AM     Permit Number 14473 6007510.46945444 2113541.05571027 37.7838050881462 -122.417714890881 (37.7838050881462, -122.417714890881) 7 9 9 28858 36
7892 9616 Permitted Site 7 Maytenus boaria :: Mayten 58 1050X Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002926.42189 2111948.31281 37.7791727913684 -122.433460108411 (37.7791727913684, -122.433460108411) 15 9 11 29490 41
7927 17200 Permitted Site 7 Olea europaea :: Olive Tree 9 200X Olive St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006498.35844 2113758.48472 37.7843450883742 -122.421231867498 (37.7843450883742, -122.421231867498) 7 9 11 28858 41
7977 63890 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 165 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24599 6005777.74997654 2109961.71011831 37.7738794203064 -122.423454911884 (37.7738794203064, -122.423454911884) 7 9 11 28852 10
8157 8138 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 919 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003262.67464 2111347.69223 37.7775427083406 -122.432253966617 (37.7775427083406, -122.432253966617) 15 9 11 29492 10
8281 87805 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 21 Mallorca Way   Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50570 6001886.8 2119949.6 37.8010832252731 -122.437629755692 (37.8010832252731, -122.437629755692) 13 9 1 57 17
8308 143512 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2030 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 16 Width 0ft Permit Number 48982 6003288.5063 2118622.406 37.7975186924595 -122.432684391924 (37.7975186924595, -122.432684391924) 13 9 1 57 17
8352 84946 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
8540 108986 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 58 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773047 6003766 2108010.7 37.7684086713102 -122.430274662073 (37.7684086713102, -122.430274662073) 7 9 5 28862 3
8584 21731 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1963 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/1997 12:00:00 AM 3 3X3   6003249.5114044 2114468.5359796 37.7861110165037 -122.432522471352 (37.7861110165037, -122.432522471352) 13 9 11 29490 13
8752 7916 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1225 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6005951.06937 2114267.1292 37.7857108313539 -122.423161466763 (37.7857108313539, -122.423161466763) 13 9 1 28858 41
8883 261542 Permitted Site 7 :: 45 1305 Lombard St 1 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 10x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
8885 60056 Permitted Site 7 Tree(s) :: 17 2806 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/1982 12:00:00 AM     Permit Number 19555 6000126.85269277 2117488.31614972 37.7942249702165 -122.443543007615 (37.7942249702165, -122.443543007615) 13 9 1 57 27
8914 7995 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2250 Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1992 12:00:00 AM 12 3x3   6005514.59005 2117689.16769 37.7950822509185 -122.424915114283 (37.7950822509185, -122.424915114283) 13 9 1 28858 27
8927 88820 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 55 Page St 24 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2008 12:00:00 AM   3x3 Permit Number 51708 6006333 2111428 37.7779368220791 -122.421638371919 (37.7779368220791, -122.421638371919) 7 9 11 28852 10
8975 256665 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 5x5 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
8986 8479 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1900X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3X3   6002632.5922648 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971) 13 9 11 29490 13
9026 23835 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1990 12:00:00 AM 20 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
9037 87895 Permitted Site 7 Melaleuca spp :: Melaleuca spp 117 333 Fell St 12 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2008 12:00:00 AM   3x3 Permit Number 50914 6005838.683161 2110670.713999 37.7758296125272 -122.423294544203 (37.7758296125272, -122.423294544203) 7 9 11 28852 10
9084 52119 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 700 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM   3x3 Permit Number 48306 6004489.25693114 2110876.3075584 37.7763178722928 -122.427977208208 (37.7763178722928, -122.427977208208) 7 9 11 28852 10
9470 46514 Permitted Site 7 Ceratonia siliqua :: Carob 5 525or larger Golden Gate Ave In A 24 Box 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44680 6007056.20383649 2112568.41573989 37.7811088818185 -122.419217465788 (37.7811088818185, -122.419217465788) 7 9 9 28852 36
9567 143511 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003307.4663 2118627.6363 37.7975341287535 -122.432619159147 (37.7975341287535, -122.432619159147) 13 9 1 57 17
9622 64841 Permitted Site 7 Tree(s) :: 17 2715 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1989 12:00:00 AM     Permit Number 25853 6001106.5651027 2117655.58396036 37.7947400688298 -122.440165102012 (37.7947400688298, -122.440165102012) 13 9 1 57 27
9766 14759 Permitted Site 7 Rhaphiolepis indica :: India Hawthorn 293 963 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1997 12:00:00 AM 6 4X4   6004543.30583 2111878.13502 37.7790717017782 -122.42786163982 (37.7790717017782, -122.42786163982) 7 9 11 29490 41
9842 114329 Permitted Site 7 Tree(s) :: 17 1701X Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776565 6004666.60531 2118440.00919 37.7970959359465 -122.427902799084 (37.7970959359465, -122.427902799084) 13 9 1 57 17

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