trees
39,840 rows where qLegalStatus_id = 7 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );