trees
443 rows where qSpecies_id = 32 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
4937 | 132212 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000265.26964 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | 13 | 9 | 1 | 57 | 17 | |||
5052 | 139847 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 829 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005684.1962 | 2112380.729 | 37.7805161769301 | -122.423950581978 | (37.7805161769301, -122.423950581978) | 7 | 9 | 11 | 28852 | 41 | |||
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 | ||
10382 | 70244 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005809.1541 | 2110870.1551 | 37.7763755628652 | -122.423410874448 | (37.7763755628652, -122.423410874448) | 7 | 9 | 11 | 28852 | 10 | |||
13057 | 73861 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005837.5808 | 2110875.7018 | 37.7763923971267 | -122.423312932793 | (37.7763923971267, -122.423312932793) | 7 | 9 | 11 | 28852 | 10 | |||
14931 | 132217 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999261.04653 | 2118404.81755 | 37.7966920235835 | -122.446604753326 | (37.7966920235835, -122.446604753326) | 13 | 9 | 1 | 57 | 17 | |||
17446 | 9465 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
18592 | 111041 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004870.73043 | 2118877.40927 | 37.7983084704282 | -122.427227648441 | (37.7983084704282, -122.427227648441) | 13 | 9 | 1 | 57 | 17 | |||
23719 | 132215 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999237.1134 | 2118402.93591 | 37.7966854900001 | -122.446687431602 | (37.7966854900001, -122.446687431602) | 13 | 9 | 1 | 57 | 17 | |||
24832 | 9460 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/1998 12:00:00 AM | 6 | 3X3 | 6005350.8775 | 2112393.4845 | 37.7805323769118 | -122.425104597895 | (37.7805323769118, -122.425104597895) | 7 | 9 | 11 | 28852 | 41 | ||
26805 | 139841 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 855 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005489.2243 | 2112352.6717 | 37.7804281291994 | -122.424623086227 | (37.7804281291994, -122.424623086227) | 7 | 9 | 11 | 28852 | 41 | |||
27892 | 9514 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1024 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004658.34921 | 2112287.36137 | 37.7802018438259 | -122.427492819652 | (37.7802018438259, -122.427492819652) | 7 | 9 | 11 | 29490 | 41 | ||
36402 | 16950 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.7741905079368 | -122.429770337641 | (37.7741905079368, -122.429770337641) | 7 | 9 | 11 | 29492 | 10 | |||
37811 | 111042 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004867.45543 | 2118890.27835 | 37.7983436204214 | -122.42723989811 | (37.7983436204214, -122.42723989811) | 13 | 9 | 1 | 57 | 17 | |||
37896 | 9519 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1042 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6004584.56967 | 2112292.20585 | 37.780210972327 | -122.427748402246 | (37.780210972327, -122.427748402246) | 7 | 9 | 11 | 29490 | 41 | ||
39346 | 50453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2645 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | Permit Number 47099 | 5999591.19502 | 2117968.49826 | 37.7955128594886 | -122.445430979754 | (37.7955128594886, -122.445430979754) | 13 | 9 | 1 | 57 | 17 | ||
40789 | 9455 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | 7 | 9 | 11 | 28852 | 41 | ||
46316 | 9558 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1195X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | ||
49344 | 139946 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005060.605 | 2112352.3265 | 37.7804029654412 | -122.426105857766 | (37.7804029654412, -122.426105857766) | 7 | 9 | 11 | 28852 | 41 | |||
51716 | 9452 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.7806057683483 | -122.424527345883 | (37.7806057683483, -122.424527345883) | 7 | 9 | 11 | 28852 | 41 | ||
53615 | 233359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 93 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6004257.74689 | 2109007.55308 | 37.7711736292001 | -122.428644822623 | (37.7711736292001, -122.428644822623) | 7 | 9 | 11 | 29492 | 10 | |||
54476 | 49993 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300@ GOUGH Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005892.354 | 2110883.3284 | 37.776416429024 | -122.423123998881 | (37.776416429024, -122.423123998881) | 7 | 9 | 11 | 28852 | 10 | ||
61436 | 54918 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2836 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 9 | Permit Number 10785 | 5999351.3134 | 2118417.61273 | 37.7967323114142 | -122.446293331595 | (37.7967323114142, -122.446293331595) | 13 | 9 | 1 | 57 | 17 | ||
67414 | 139945 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005081.184 | 2112356.1174 | 37.7804145374079 | -122.426034935273 | (37.7804145374079, -122.426034935273) | 7 | 9 | 11 | 28852 | 41 | |||
69752 | 132213 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000167.6867 | 2118186.05064 | 37.7961430935947 | -122.443451860639 | (37.7961430935947, -122.443451860639) | 13 | 9 | 1 | 57 | 17 | |||
72362 | 139831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 925 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005175.7373 | 2112309.654 | 37.7802923037704 | -122.42570452289 | (37.7802923037704, -122.42570452289) | 7 | 9 | 11 | 28852 | 41 | |||
73865 | 233504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 303 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004169.36699 | 2109042.82598 | 37.7712654778421 | -122.428953047263 | (37.7712654778421, -122.428953047263) | 7 | 9 | 11 | 29492 | 10 | |||
82188 | 32003 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2648 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 7 | Permit Number 35399 | 6000296.93169 | 2118203.44965 | 37.7961982364164 | -122.4430058985 | (37.7961982364164, -122.4430058985) | 13 | 9 | 1 | 57 | 17 | ||
82697 | 49986 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300@ GOUGH Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005905.5273 | 2110882.6351 | 37.7764152687747 | -122.42307837937 | (37.7764152687747, -122.42307837937) | 7 | 9 | 11 | 28852 | 10 | ||
82766 | 62895 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1986 12:00:00 AM | 7 | Permit Number 23269 | 6000188.22889 | 2118188.91865 | 37.7961521398507 | -122.443380986865 | (37.7961521398507, -122.443380986865) | 13 | 9 | 1 | 57 | 17 | ||
85920 | 139838 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 875 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005379.6259 | 2112337.1416 | 37.7803792970953 | -122.425001133553 | (37.7803792970953, -122.425001133553) | 7 | 9 | 11 | 28852 | 41 | |||
87307 | 141826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1020 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004640.8141 | 2112287.0177 | 37.7801999083923 | -122.427553457164 | (37.7801999083923, -122.427553457164) | 7 | 9 | 11 | 29490 | 41 | |||
91576 | 96266 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 3 | 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 | |||
92938 | 139937 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800 GOLDEN GATE AVE | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005368.7488 | 2112395.1092 | 37.7805378474705 | -122.425042888178 | (37.7805378474705, -122.425042888178) | 7 | 9 | 11 | 28852 | 41 | |||
95260 | 96264 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 1 | 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 | |||
96009 | 132214 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000146.66842 | 2118183.0353 | 37.7961336156155 | -122.443524371168 | (37.7961336156155, -122.443524371168) | 13 | 9 | 1 | 57 | 17 | |||
99887 | 9457 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | 7 | 9 | 11 | 28852 | 41 | |||
101848 | 132211 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004866.10803 | 2118906.26122 | 37.7983874290946 | -122.427245699623 | (37.7983874290946, -122.427245699623) | 13 | 9 | 1 | 57 | 17 | |||
107705 | 9458 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.7805495105702 | -122.424966344778 | (37.7805495105702, -122.424966344778) | 7 | 9 | 11 | 28852 | 41 | ||
107832 | 9453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.424574106032 | (37.7806020298362, -122.424574106032) | 7 | 9 | 11 | 28852 | 41 | ||
110100 | 12389 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1450 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
113333 | 32004 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2648 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 4 | Permit Number 35399 | 6000314.48806 | 2118206.69354 | 37.7962081442408 | -122.44294538314 | (37.7962081442408, -122.44294538314) | 13 | 9 | 1 | 57 | 17 | ||
113569 | 9450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 6 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.7806176146029 | -122.424439561439 | (37.7806176146029, -122.424439561439) | 7 | 9 | 11 | 28852 | 41 | |||
114657 | 9454 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | 7 | 9 | 11 | 28852 | 41 | ||
123609 | 139845 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005645.4131 | 2112373.0828 | 37.7804929927223 | -122.424084207294 | (37.7804929927223, -122.424084207294) | 7 | 9 | 11 | 28852 | 41 | |||
130406 | 233503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004006.37155 | 2109072.69928 | 37.7713382752792 | -122.429518986121 | (37.7713382752792, -122.429518986121) | 7 | 9 | 11 | 29492 | 10 | |||
131234 | 132216 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999249.48209 | 2118404.06668 | 37.7966893013211 | -122.446644714701 | (37.7966893013211, -122.446644714701) | 13 | 9 | 1 | 57 | 17 | |||
134854 | 9492 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 875 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X | 6005394.0418 | 2112324.36064 | 37.7803450180147 | -122.424950352589 | (37.7803450180147, -122.424950352589) | 7 | 9 | 11 | 28852 | 41 | ||
151176 | 9500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 915 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005267.772 | 2112322.2041 | 37.7803319634813 | -122.425387025394 | (37.7803319634813, -122.425387025394) | 7 | 9 | 11 | 28852 | 41 | ||
156550 | 9488 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 855 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005478.3549 | 2112356.31338 | 37.7804375144956 | -122.424660947747 | (37.7804375144956, -122.424660947747) | 7 | 9 | 11 | 28852 | 41 | ||
159942 | 141827 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1040 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004564.2329 | 2112276.6178 | 37.7801670209735 | -122.427817645466 | (37.7801670209735, -122.427817645466) | 7 | 9 | 11 | 29490 | 41 | |||
163748 | 132218 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999271.44145 | 2118406.78235 | 37.796698012158 | -122.446568926118 | (37.796698012158, -122.446568926118) | 13 | 9 | 1 | 57 | 17 | |||
170214 | 57728 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52544 | 6004003.00672697 | 2109073.0127901 | 37.7713389455863 | -122.429530647558 | (37.7713389455863, -122.429530647558) | 7 | 9 | 11 | 29492 | 10 | ||
172455 | 9471 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 27 | 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 | ||
177686 | 9503 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 925 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005161.80896 | 2112312.16407 | 37.7802984087399 | -122.425752886207 | (37.7802984087399, -122.425752886207) | 7 | 9 | 11 | 28852 | 41 | ||
180969 | 139955 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004851.0238 | 2112323.6242 | 37.7803123083991 | -122.426828852854 | (37.7803123083991, -122.426828852854) | 7 | 9 | 11 | 28852 | 41 | |||
182151 | 233505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 303 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004187.87714 | 2109045.00996 | 37.7712725222301 | -122.428889175598 | (37.7712725222301, -122.428889175598) | 7 | 9 | 11 | 29492 | 10 | |||
192662 | 9763 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 827X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005605.94462 | 2112369.06058 | 37.7804797202246 | -122.424220461395 | (37.7804797202246, -122.424220461395) | 7 | 9 | 11 | 28852 | 41 | ||
2706 | 211314 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993864.84081 | 2102208.58731 | 37.7519117832189 | -122.464100354143 | (37.7519117832189, -122.464100354143) | 1 | 8 | 4 | 29491 | 12 | |||
4051 | 260659 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
8550 | 260661 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9356 | 260660 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
13269 | 211313 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.24128 | 2099598.30232 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | 1 | 8 | 4 | 29491 | 40 | |||
16610 | 211317 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993928.12229 | 2102221.55917 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | 1 | 8 | 4 | 29491 | 12 | |||
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
17511 | 260658 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
18441 | 260662 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
25550 | 211315 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993849.45223 | 2102159.58974 | 37.7517763614982 | -122.464150012924 | (37.7517763614982, -122.464150012924) | 1 | 8 | 4 | 29491 | 12 | |||
30327 | 34199 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 38018 | 5994287.68885518 | 2098749.96127524 | 37.7424396309737 | -122.462387263533 | (37.7424396309737, -122.462387263533) | 1 | 8 | 4 | 59 | 40 | ||
58134 | 38018 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
98544 | 211316 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993952.85587 | 2102199.15235 | 37.7518909495221 | -122.463795303226 | (37.7518909495221, -122.463795303226) | 1 | 8 | 4 | 29491 | 40 | |||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
132142 | 100385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2012 12:00:00 AM | 3x3 | Permit Number 769433 | 5990171 | 2106556 | 37.7636350362567 | -122.477191710239 | (37.7636350362567, -122.477191710239) | 1 | 8 | 3 | 56 | 35 | ||
141605 | 38019 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
144217 | 104308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2013 12:00:00 AM | 3x3 | Permit Number 770798 | 5995451.6 | 2089938.7 | 37.7183129950309 | -122.457725404768 | (37.7183129950309, -122.457725404768) | 9 | 8 | 6 | 28861 | 24 | ||
149706 | 89031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53922 | 5993414.1 | 2105027.2 | 37.7596249765547 | -122.465863845757 | (37.7596249765547, -122.465863845757) | 1 | 8 | 4 | 56 | 12 | |
184152 | 63700 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53921 | 5993398.86039614 | 2105062.95124939 | 37.7597222610505 | -122.465919149256 | (37.7597222610505, -122.465919149256) | 1 | 8 | 4 | 56 | 12 | |
191498 | 211311 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995443.13465 | 2089926.39084 | 37.7182787106718 | -122.457753775529 | (37.7182787106718, -122.457753775529) | 9 | 8 | 6 | 28861 | 24 | |||
57 | 230549 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 39 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787877 | 6005359.28388 | 2095944.60166 | 37.7353680760624 | -122.423905517743 | (37.7353680760624, -122.423905517743) | 2 | 7 | 7 | 28859 | 2 | |
613 | 161126 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001694.7774 | 2090903.55181 | 37.721318940793 | -122.436214417168 | (37.721318940793, -122.436214417168) | 9 | 7 | 6 | 28861 | 5 | ||
2889 | 211318 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 355 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997726.4515 | 2093787.92348 | 37.7290124835257 | -122.450139532341 | (37.7290124835257, -122.450139532341) | 9 | 7 | 4 | 28861 | 40 | |||
3506 | 161128 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001711.00806 | 2090931.14538 | 37.7213956286903 | -122.436160286079 | (37.7213956286903, -122.436160286079) | 9 | 7 | 6 | 28861 | 5 | ||
6345 | 175597 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6001092.21629 | 2090034.68248 | 37.7188989677059 | -122.438235084102 | (37.7188989677059, -122.438235084102) | 9 | 7 | 6 | 28861 | 5 | ||
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
10399 | 161129 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001722.11588 | 2090948.37155 | 37.7214435589648 | -122.436123121581 | (37.7214435589648, -122.436123121581) | 9 | 7 | 6 | 28861 | 5 | ||
11621 | 171168 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 61 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004706.69577 | 2093156.0367 | 37.7276744353238 | -122.425963318556 | (37.7276744353238, -122.425963318556) | 9 | 7 | 6 | 28861 | 5 | |||
13489 | 160999 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 265 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6004550.61216 | 2090876.91947 | 37.7214076589281 | -122.426340700176 | (37.7214076589281, -122.426340700176) | 9 | 7 | 6 | 28861 | 5 | ||
14913 | 233381 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008152.13666 | 2096545.8865 | 37.7371763483116 | -122.414292086129 | (37.7371763483116, -122.414292086129) | 2 | 7 | 7 | 28859 | 2 | |||
15217 | 161127 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001702.30852 | 2090917.36085 | 37.7213572852021 | -122.436189371961 | (37.7213572852021, -122.436189371961) | 9 | 7 | 6 | 28861 | 5 | ||
16103 | 247814 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 532 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | 2 | 7 | 5 | 63 | 22 | |||
17190 | 233382 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008169.60603 | 2096545.72694 | 37.7371768914874 | -122.414231675074 | (37.7371768914874, -122.414231675074) | 2 | 7 | 7 | 28859 | 2 | |||
19222 | 22826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 84 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:48:00 PM | 3 | 3x3 | 5999343.3761 | 2099052.93009 | 37.743561341476 | -122.444928046502 | (37.743561341476, -122.444928046502) | 2 | 7 | 5 | 63 | 7 | ||
23779 | 233442 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 95 Montezuma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007954.1776 | 2099786.14211 | 37.7460622517822 | -122.415205824295 | (37.7460622517822, -122.415205824295) | 2 | 7 | 7 | 28859 | 2 | |||
23903 | 107340 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 |
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) );