trees
443 rows where qSpecies_id = 32 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||
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 | |||
117702 | 233490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 918 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001888.71802 | 2101354.60643 | 37.7500261396126 | -122.436291586193 | (37.7500261396126, -122.436291586193) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
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 | |||
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 | |||
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 | |||
164883 | 253370 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 896 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012140.05864 | 2104123.74749 | 37.7582067293333 | -122.401036229519 | (37.7582067293333, -122.401036229519) | 10 | 3 | 8 | 28856 | 29 | |||
28716 | 233494 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003128.49899 | 2103230.63077 | 37.7552476232057 | -122.432138316435 | (37.7552476232057, -122.432138316435) | 2 | 4 | 5 | 28862 | 22 | |||
86394 | 81256 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50448 | 6003133.58124947 | 2103094.76960314 | 37.7548748688717 | -122.432111038861 | (37.7548748688717, -122.432111038861) | 2 | 4 | 5 | 28862 | 22 | ||
178051 | 63992 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 880 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 10 | Permit Number 24739 | 6008138.72645 | 2120344.34262 | 37.802520572028 | -122.416023302632 | (37.802520572028, -122.416023302632) | 5 | 1 | 10 | 308 | 32 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
126321 | 118491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981413.14873 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | 11 | 6 | 2 | 55 | 26 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
13031 | 261121 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 80 Vesta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
146239 | 40842 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 736 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1999 12:00:00 AM | 4 | Permit Number 41768 | 6003877.32471 | 2090996.85853 | 37.7216989034509 | -122.428676613636 | (37.7216989034509, -122.428676613636) | 9 | 7 | 6 | 28861 | 5 | ||
84326 | 233436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000375.83482 | 2101284.56019 | 37.7497477337837 | -122.441518177039 | (37.7497477337837, -122.441518177039) | 2 | 4 | 5 | 28862 | 22 | |||
182963 | 109449 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773467 | 6000399 | 2101283.9 | 37.7497472407948 | -122.441438023758 | (37.7497472407948, -122.441438023758) | 2 | 4 | 5 | 28862 | 22 |
182852 | 115200 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 716 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774286 | 6004934.3 | 2104152.6 | 37.7578813515637 | -122.425958943462 | (37.7578813515637, -122.425958943462) | 2 | 4 | 5 | 28862 | 3 | |||
141011 | 5490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 714 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 12/28/2015 12:00:00 AM | 1 | 4X4 | Permit Number 774286 | 6004953.58017 | 2104162.27117 | 37.7579089959252 | -122.425892952911 | (37.7579089959252, -122.425892952911) | 2 | 4 | 5 | 28862 | 3 |
160348 | 117434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 71 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775886 | 6000675.58728 | 2092024.5104 | 37.7243388786085 | -122.439817790169 | (37.7243388786085, -122.439817790169) | 9 | 7 | 6 | 28861 | 25 | ||
83677 | 178356 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009662.10656 | 2090649.30438 | 37.7210702863525 | -122.408655555513 | (37.7210702863525, -122.408655555513) | 9 | 3 | 7 | 309 | 28 | |||
136531 | 178357 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | 9 | 3 | 7 | 309 | 28 | |||
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 | ||
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 | |||
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 | ||
137193 | 233435 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001680.56547 | 2099436.84867 | 37.7447486021689 | -122.436874115749 | (37.7447486021689, -122.436874115749) | 2 | 7 | 5 | 63 | 22 | |||
171861 | 35805 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 633 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39049 | 6007507.54352575 | 2105966.04756896 | 37.7630057507472 | -122.417188065421 | (37.7630057507472, -122.417188065421) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
26684 | 194530 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 616 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012360.41946 | 2105070.75065 | 37.7608192812075 | -122.400340636111 | (37.7608192812075, -122.400340636111) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
1087 | 233496 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000227.44313 | 2104506.90628 | 37.7585870568739 | -122.442262614226 | (37.7585870568739, -122.442262614226) | 2 | 4 | 5 | 28862 | 3 | |||
98646 | 233497 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000229.80091 | 2104520.72602 | 37.7586251368655 | -122.442255452052 | (37.7586251368655, -122.442255452052) | 2 | 4 | 5 | 28862 | 3 | |||
42988 | 233501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Park Hill Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001141.15752 | 2107828.11381 | 37.7677583098187 | -122.439340644067 | (37.7677583098187, -122.439340644067) | 15 | 5 | 5 | 29492 | 3 | |||
138417 | 233502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Park Hill Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001148.61748 | 2107774.29044 | 37.7676109487195 | -122.439310982617 | (37.7676109487195, -122.439310982617) | 15 | 5 | 5 | 29492 | 3 | |||
10926 | 39982 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 41240 | 6013913.21051 | 2094747.21056 | 37.7325594879289 | -122.394247383904 | (37.7325594879289, -122.394247383904) | 10 | 3 | 8 | 58 | 1 |
96920 | 63999 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 595 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778275 | 6001356.36107438 | 2100834.50333121 | 37.7485677985315 | -122.438095249236 | (37.7485677985315, -122.438095249236) | 2 | 4 | 5 | 28862 | 22 | |
114649 | 194547 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.7378863594562 | -122.381824001685 | (37.7378863594562, -122.381824001685) | 10 | 3 | 8 | 58 | 1 | |||
148038 | 233491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 580 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001369.26473 | 2101468.92323 | 37.7503104980297 | -122.438096067791 | (37.7503104980297, -122.438096067791) | 2 | 4 | 5 | 28862 | 22 | |||
41355 | 233444 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 550 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008943.54887 | 2105635.82599 | 37.7621797198454 | -122.412198056097 | (37.7621797198454, -122.412198056097) | 8 | 4 | 7 | 28859 | 19 | |||
46793 | 233443 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 550 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008940.03801 | 2105662.09914 | 37.7622516628983 | -122.412212055847 | (37.7622516628983, -122.412212055847) | 8 | 4 | 7 | 28859 | 19 | |||
160388 | 37944 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 547 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2006 12:00:00 AM | 4 | Permit Number 48880 | 6013009.69934 | 2104469.29926 | 37.7592040124698 | -122.398052855272 | (37.7592040124698, -122.398052855272) | 10 | 3 | 8 | 28856 | 29 | |
55259 | 178358 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 54 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004690.16722 | 2093211.84688 | 37.7278267435864 | -122.426024429306 | (37.7278267435864, -122.426024429306) | 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 | |||
84140 | 233377 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007431.42413 | 2096297.49525 | 37.7364538095851 | -122.416766332396 | (37.7364538095851, -122.416766332396) | 2 | 7 | 7 | 28859 | 2 | |||
107332 | 233378 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007432.33067 | 2096315.60507 | 37.7365035861596 | -122.416764480695 | (37.7365035861596, -122.416764480695) | 2 | 7 | 7 | 28859 | 2 | |||
73390 | 14514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.7765051848822 | -122.446711235239 | (37.7765051848822, -122.446711235239) | 15 | 5 | 2 | 29492 | 16 | |||
33438 | 35878 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011145.10995 | 2096599.24748 | 37.7374905363641 | -122.403947710713 | (37.7374905363641, -122.403947710713) | 10 | 3 | 8 | 58 | 1 | |
97002 | 35881 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011145.59946 | 2096623.30558 | 37.7375566221413 | -122.403947710744 | (37.7375566221413, -122.403947710744) | 10 | 3 | 8 | 58 | 1 | |
97777 | 35879 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 8 | Permit Number 39083 | 6011139.9615 | 2096662.77409 | 37.7376646792858 | -122.403969980625 | (37.7376646792858, -122.403969980625) | 10 | 3 | 8 | 58 | 1 | |
120951 | 35880 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011141.46747 | 2096642.94504 | 37.7376103170696 | -122.403963378733 | (37.7376103170696, -122.403963378733) | 10 | 3 | 8 | 58 | 1 | |
158092 | 233445 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 490 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007223.95865 | 2104457.82895 | 37.7588485743169 | -122.418061963207 | (37.7588485743169, -122.418061963207) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
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 | ||
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 | ||
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 | ||
40487 | 96154 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
193803 | 96153 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
34960 | 115370 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887 | 2096619.6 | 37.7373638523191 | -122.415214003631 | (37.7373638523191, -122.415214003631) | 2 | 7 | 7 | 28859 | 2 | ||
173349 | 233439 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007870.12946 | 2096618.1338 | 37.7373588783147 | -122.415272229338 | (37.7373588783147, -122.415272229338) | 2 | 7 | 7 | 28859 | 2 | |||
134754 | 233376 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 476 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003431.53598 | 2100120.0067 | 37.7467237571152 | -122.430868343305 | (37.7467237571152, -122.430868343305) | 2 | 7 | 5 | 63 | 22 | |||
34340 | 45171 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44018 | 6010456.17942581 | 2099626.75633158 | 37.7457649076199 | -122.406542957313 | (37.7457649076199, -122.406542957313) | 2 | 7 | 7 | 28859 | 2 | ||
163353 | 248106 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010434.28428 | 2099597.55931 | 37.7456835139995 | -122.406616610788 | (37.7456835139995, -122.406616610788) | 2 | 7 | 7 | 28859 | 2 | |||
43234 | 233495 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 450 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003394.34799 | 2103331.88494 | 37.7555407122568 | -122.431226159276 | (37.7555407122568, -122.431226159276) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
66612 | 233437 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4221 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002351.48314 | 2100601.8225 | 37.7479854555773 | -122.434637500016 | (37.7479854555773, -122.434637500016) | 2 | 4 | 5 | 63 | 22 | |||
10542 | 233492 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001776.45872 | 2103391.52743 | 37.7556126580189 | -122.436825582043 | (37.7556126580189, -122.436825582043) | 2 | 4 | 5 | 28862 | 22 | |||
129097 | 233493 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001723.63115 | 2103489.69631 | 37.7558792035671 | -122.437015303929 | (37.7558792035671, -122.437015303929) | 2 | 4 | 5 | 28862 | 22 | |||
132630 | 51917 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2006 12:00:00 AM | Permit Number 48118 | 6001789.43433007 | 2103492.65068775 | 37.7558910555827 | -122.436787946951 | (37.7558910555827, -122.436787946951) | 2 | 4 | 5 | 28862 | 22 | ||
123083 | 233500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4090 20th St | 10 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.432310971886 | (37.7578610449587, -122.432310971886) | 2 | 4 | 5 | 28862 | 3 | |||
106723 | 60332 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | 3x3 | Permit Number 770595 | 6002797.86052916 | 2104715.61000638 | 37.7593062690744 | -122.433387871218 | (37.7593062690744, -122.433387871218) | 2 | 4 | 5 | 28862 | 3 | ||
168397 | 233499 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002782.35328 | 2104714.28422 | 37.7593017489969 | -122.43344140802 | (37.7593017489969, -122.43344140802) | 2 | 4 | 5 | 28862 | 3 | |||
12121 | 11883 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017703.73127 | 2096843.30561 | 37.7385249167977 | -122.381288201801 | (37.7385249167977, -122.381288201801) | 10 | 3 | 8 | 58 | 1 | |||
65099 | 28133 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2018 12:00:00 AM | 3 | 6x9 | Permit Number 778832 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | 2 | 7 | 7 | 28859 | 2 | |
47154 | 233360 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 40 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005303.62865 | 2105767.86216 | 37.7623373467104 | -122.42479655971 | (37.7623373467104, -122.42479655971) | 8 | 4 | 5 | 28859 | 19 | |||
166993 | 35785 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 40 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39037 | 6005293.11940108 | 2105777.11117211 | 37.7623621487297 | -122.424833565344 | (37.7623621487297, -122.424833565344) | 8 | 4 | 5 | 28859 | 19 | ||
68145 | 194540 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012505.10498 | 2107346.22269 | 37.7670752882293 | -122.400000029601 | (37.7670752882293, -122.400000029601) | 14 | 3 | 8 | 28856 | 20 | |||
73030 | 194539 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012519.55617 | 2107331.82323 | 37.767036556231 | -122.399949033536 | (37.767036556231, -122.399949033536) | 14 | 3 | 8 | 28856 | 20 | |||
75963 | 194537 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012568.21907 | 2107279.59323 | 37.7668958572755 | -122.399777047179 | (37.7668958572755, -122.399777047179) | 14 | 3 | 8 | 28856 | 20 |
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) );