trees
443 rows where qSpecies_id = 32 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
18435 | 261120 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2901 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
74150 | 199995 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1094 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6017857.178 | 2092387.3649 | 37.7262982485858 | -122.380448036499 | (37.7262982485858, -122.380448036499) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
132838 | 26467 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2016 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
30724 | 200624 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1382 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016324.8756 | 2094912.2277 | 37.7331463494491 | -122.385921096754 | (37.7331463494491, -122.385921096754) | 10 | 3 | 8 | 58 | 1 | |||
188244 | 199695 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1350 Underwood Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6015882.1777 | 2092801.0091 | 37.7273248550401 | -122.387304416847 | (37.7273248550401, -122.387304416847) | 10 | 3 | 8 | 58 | 1 | |||
4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
157112 | 256075 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 1919 Jennings St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015778 | 2093027 | 37.7279396111572 | -122.387680322808 | (37.7279396111572, -122.387680322808) | 10 | 3 | 8 | 58 | 1 | |||||
104740 | 29645 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.387694661666 | (37.7359363605469, -122.387694661666) | 10 | 3 | 8 | 58 | 1 | ||
131306 | 3871 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
159163 | 3872 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
136895 | 29646 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | 10 | 3 | 8 | 58 | 1 | ||
153544 | 29647 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 6 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015782.349 | 2095974.6757 | 37.7360335786804 | -122.387870882274 | (37.7360335786804, -122.387870882274) | 10 | 3 | 8 | 58 | 1 | ||
47331 | 29648 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 7 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015756.6041 | 2095993.5134 | 37.7360838769453 | -122.38796120765 | (37.7360838769453, -122.38796120765) | 10 | 3 | 8 | 58 | 1 | ||
36781 | 29649 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 8 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015738.3943 | 2096009.2115 | 37.7361259719003 | -122.388025261983 | (37.7361259719003, -122.388025261983) | 10 | 3 | 8 | 58 | 1 | ||
26149 | 29650 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 9 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015718.9286 | 2096019.8862 | 37.7361542039988 | -122.388093308135 | (37.7361542039988, -122.388093308135) | 10 | 3 | 8 | 58 | 1 | ||
40590 | 199686 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015608.757 | 2092907.6605 | 37.7276025523971 | -122.388257080086 | (37.7276025523971, -122.388257080086) | 10 | 3 | 8 | 58 | 1 | |||
171151 | 199687 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015600.4454 | 2092895.2979 | 37.7275681466115 | -122.388284951178 | (37.7275681466115, -122.388284951178) | 10 | 3 | 8 | 58 | 1 | |||
15836 | 199688 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015592.0163 | 2092881.2495 | 37.7275291054366 | -122.388313110838 | (37.7275291054366, -122.388313110838) | 10 | 3 | 8 | 58 | 1 | |||
153206 | 53194 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1465@ KEITH Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49131 | 6015294.6422 | 2093162.1043 | 37.7282837944132 | -122.389360748448 | (37.7282837944132, -122.389360748448) | 10 | 3 | 8 | 58 | 1 | |
189302 | 256060 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1560 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014829 | 2093598 | 37.7294548494407 | -122.391000959828 | (37.7294548494407, -122.391000959828) | 10 | 3 | 8 | 58 | 1 | ||||
130450 | 194526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 15 | : Yard | Tree | Private 2 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.391045631074 | (37.7530413020381, -122.391045631074) | 10 | 3 | 8 | 28856 | 29 | ||||
125810 | 194528 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 21 | : Yard | Tree | Private 2 | 3 | 6014977.55524 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | 10 | 3 | 8 | 28856 | 29 | ||||
144108 | 194527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 16 | : Yard | Tree | Private 2 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.391114093749 | (37.7530595798584, -122.391114093749) | 10 | 3 | 8 | 28856 | 29 | ||||
181825 | 194529 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 23 | : Yard | Tree | Private 2 | 2 | 6014967.18541 | 2102296.35434 | 37.753346400626 | -122.391130987502 | (37.753346400626, -122.391130987502) | 10 | 3 | 8 | 28856 | 29 | ||||
127261 | 194536 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 150 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014975.61342 | 2110964.15152 | 37.7771467490639 | -122.391707837847 | (37.7771467490639, -122.391707837847) | 6 | 2 | 9 | 28856 | 20 | |||
119135 | 45703 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2002 12:00:00 AM | Permit Number 44377 | 6014535.62783282 | 2096937.66705225 | 37.7386086105091 | -122.392248663491 | (37.7386086105091, -122.392248663491) | 10 | 3 | 8 | 58 | 1 | ||
43559 | 194534 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 25 Lucy St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014175.87087 | 2093939.45878 | 37.7303561623911 | -122.39328279268 | (37.7303561623911, -122.39328279268) | 10 | 3 | 8 | 58 | 1 | |||
52158 | 194535 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 360 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014325.43113 | 2111634.88834 | 37.7789523278141 | -122.394004006676 | (37.7789523278141, -122.394004006676) | 6 | 2 | 9 | 28856 | 34 | |||
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 |
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 | |
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 | |||
7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
191856 | 194538 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012547.84553 | 2107301.30971 | 37.7669543500844 | -122.399849041507 | (37.7669543500844, -122.399849041507) | 14 | 3 | 8 | 28856 | 20 | |||
21926 | 194544 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012545.36949 | 2107606.50724 | 37.7677922160651 | -122.399879039311 | (37.7677922160651, -122.399879039311) | 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 | |||
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 | |||
89574 | 194545 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.7676657471131 | -122.400048025518 | (37.7676657471131, -122.400048025518) | 14 | 3 | 8 | 28856 | 20 | |||
119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
121600 | 194541 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012465.16673 | 2107386.76068 | 37.7671843696864 | -122.40014101809 | (37.7671843696864, -122.40014101809) | 14 | 3 | 8 | 28856 | 20 | |||
125518 | 194542 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012450.21381 | 2107404.91238 | 37.7672333764343 | -122.400194013336 | (37.7672333764343, -122.400194013336) | 14 | 3 | 8 | 28856 | 20 | |||
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 | |||
91109 | 253371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | 10 | 3 | 8 | 28856 | 29 | |||
148734 | 253372 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
157819 | 150468 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012105.23351 | 2104143.6419 | 37.7582594122512 | -122.401158068605 | (37.7582594122512, -122.401158068605) | 10 | 3 | 8 | 28856 | 29 | |
83366 | 45466 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2211 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44247 | 6011994.00463493 | 2101339.69847182 | 37.7505541915496 | -122.401345703709 | (37.7505541915496, -122.401345703709) | 10 | 3 | 8 | 28856 | 1 | |||
190411 | 150469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012042.59416 | 2104165.28662 | 37.7583153491828 | -122.401376225239 | (37.7583153491828, -122.401376225239) | 10 | 3 | 8 | 28856 | 29 | |
3388 | 261119 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 | ||
118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
44013 | 87743 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 335 Wilde Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | 9 | 7 | 8 | 309 | 39 | |||
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 | |
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 | |
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 | |
192710 | 249942 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011270.23997 | 2120024.6306 | 37.801818286952 | -122.405164122933 | (37.801818286952, -122.405164122933) | 3 | 1 | 10 | 308 | 23 | |||
177361 | 249944 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 6 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.54801 | 2120028.9121 | 37.8018300042211 | -122.40516681911 | (37.8018300042211, -122.40516681911) | 3 | 1 | 10 | 308 | 23 | |||
103041 | 249943 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.12703 | 2120027.36915 | 37.8018257441226 | -122.405168167193 | (37.8018257441226, -122.405168167193) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
170251 | 52758 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 22 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 774111 | 6010296.38896 | 2095344.759 | 37.733998524598 | -122.406793766427 | (37.733998524598, -122.406793766427) | 10 | 3 | 7 | 309 | 28 | ||
17666 | 52759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 22 Gaven St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2014 12:00:00 AM | 3 | Permit Number 774111 | 6010286.03762 | 2095339.86575 | 37.7339845095792 | -122.406829209621 | (37.7339845095792, -122.406829209621) | 10 | 3 | 7 | 309 | 28 | ||
81814 | 194532 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010402.10466 | 2107886.85819 | 37.7684422757183 | -122.407312137446 | (37.7684422757183, -122.407312137446) | 8 | 4 | 8 | 28853 | 19 | |||
123473 | 233367 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1113 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010291.70011 | 2102620.11112 | 37.753974797412 | -122.407322687398 | (37.753974797412, -122.407322687398) | 10 | 4 | 7 | 28859 | 19 | |||
19586 | 194533 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010348.85424 | 2107885.73513 | 37.7684362115906 | -122.40749624758 | (37.7684362115906, -122.40749624758) | 8 | 4 | 8 | 28853 | 19 | |||
55733 | 39080 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
167745 | 39073 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
98560 | 178360 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781343 | 6009991.86293 | 2095011.33058 | 37.7330659573247 | -122.40782310796 | (37.7330659573247, -122.40782310796) | 10 | 3 | 7 | 309 | 28 |
129629 | 95626 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767393 | 6010051.6 | 2104518.5 | 37.7591739071678 | -122.408286901595 | (37.7591739071678, -122.408286901595) | 2 | 4 | 7 | 28859 | 19 | |
89268 | 233371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009946.29944 | 2104530.48554 | 37.7592009197153 | -122.408651928554 | (37.7592009197153, -122.408651928554) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
120089 | 51755 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 771839 | 6009683.01299313 | 2101640.06724055 | 37.7512497292061 | -122.409358522845 | (37.7512497292061, -122.409358522845) | 2 | 4 | 7 | 28859 | 19 | |||
69826 | 233366 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009652.81284 | 2101635.24983 | 37.7512348095611 | -122.409462618807 | (37.7512348095611, -122.409462618807) | 2 | 4 | 7 | 28859 | 19 | |||
49515 | 233400 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009350.24678 | 2103328.60933 | 37.7558674377406 | -122.410628499003 | (37.7558674377406, -122.410628499003) | 2 | 4 | 7 | 28859 | 19 | |||
158235 | 233373 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3101 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009080.82321 | 2100470.36587 | 37.748004231619 | -122.411358344739 | (37.748004231619, -122.411358344739) | 2 | 7 | 7 | 28859 | 2 | |||
63965 | 233374 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3101 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009080.92209 | 2100478.86061 | 37.7480275618365 | -122.411358602837 | (37.7480275618365, -122.411358602837) | 2 | 7 | 7 | 28859 | 2 | |||
34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
50919 | 108598 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
123792 | 233403 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3071 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009068.28085 | 2100690.59156 | 37.7486082190041 | -122.411417271913 | (37.7486082190041, -122.411417271913) | 2 | 4 | 7 | 28859 | 19 | |||
139810 | 233372 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3265 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009039.47947 | 2099686.62589 | 37.7458499362223 | -122.411445948568 | (37.7458499362223, -122.411445948568) | 2 | 7 | 7 | 28859 | 2 | |||
124043 | 93976 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3261 Harrison St | : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036 | 2099698 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | 2 | 7 | 7 | 28859 | 2 | ||||
59287 | 233440 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 228 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008985.91579 | 2097299.41691 | 37.7392921796829 | -122.411462541085 | (37.7392921796829, -122.411462541085) | 10 | 7 | 7 | 28859 | 2 | |||
101767 | 233405 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | 2 | 4 | 7 | 28859 | 19 | |||
174979 | 233404 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2997 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Cleary Bros. Landscape 22 | 5 | Width 3ft | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
177011 | 233406 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2967 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009040.76192 | 2101208.50526 | 37.7500287512299 | -122.411549018972 | (37.7500287512299, -122.411549018972) | 2 | 4 | 7 | 28859 | 19 | |||
81331 | 233407 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009039.77718 | 2101237.37153 | 37.7501079563364 | -122.411554463491 | (37.7501079563364, -122.411554463491) | 2 | 4 | 7 | 28859 | 19 | |||
137671 | 233408 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2949 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009035.34127 | 2101297.66233 | 37.7502732526072 | -122.411574062399 | (37.7502732526072, -122.411574062399) | 2 | 4 | 7 | 28859 | 19 | |||
140165 | 91805 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.231108 | 2101235.143415 | 37.7501013029605 | -122.411587317077 | (37.7501013029605, -122.411587317077) | 2 | 4 | 7 | 28859 | 19 | ||
168250 | 91804 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.231108 | 2101235.143415 | 37.7501013029605 | -122.411587317077 | (37.7501013029605, -122.411587317077) | 2 | 4 | 7 | 28859 | 19 | ||
143745 | 91737 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | 2 | 4 | 7 | 28859 | 19 | |||
10685 | 233450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.7488176180461 | -122.411648631477 | (37.7488176180461, -122.411648631477) | 2 | 4 | 7 | 28859 | 19 | |||
59459 | 26520 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2859 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1X1 | 6009005.00104 | 2101862.3389 | 37.7518220263649 | -122.411718875733 | (37.7518220263649, -122.411718875733) | 2 | 4 | 7 | 28859 | 19 | |||
101913 | 26527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2011 12:00:00 AM | 3 | 3x3 | 6009007.86561 | 2102243.77418 | 37.7528695228702 | -122.411735918856 | (37.7528695228702, -122.411735918856) | 2 | 4 | 7 | 28859 | 19 | ||
26635 | 26526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | ||
40647 | 233409 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | |||
190640 | 91738 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2900x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008972.238365 | 2101556.992621 | 37.7509817758285 | -122.411810599761 | (37.7509817758285, -122.411810599761) | 2 | 4 | 7 | 28859 | 19 |
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) );