trees
443 rows where qSpecies_id = 32 sorted by Latitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17779 | 233482 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008616.65718 | 2107731.28246 | 37.7679150113072 | -122.413476857889 | (37.7679150113072, -122.413476857889) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
144188 | 233489 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1850 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008682.13256 | 2107685.30091 | 37.7677924328048 | -122.413247133243 | (37.7677924328048, -122.413247133243) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
8498 | 233506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008710.79759 | 2107246.55273 | 37.7665893413473 | -122.413116956406 | (37.7665893413473, -122.413116956406) | 8 | 4 | 7 | 28853 | 19 | |||
158444 | 233481 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008647.40135 | 2107231.86549 | 37.7665454544288 | -122.413335194872 | (37.7665454544288, -122.413335194872) | 8 | 4 | 7 | 28853 | 19 | |||
65548 | 233507 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008711.02427 | 2107230.56462 | 37.7665454544263 | -122.413115041722 | (37.7665454544263, -122.413115041722) | 8 | 4 | 7 | 28853 | 19 | |||
128475 | 233508 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008712.28974 | 2107211.2482 | 37.7664924870523 | -122.413109298673 | (37.7664924870523, -122.413109298673) | 8 | 4 | 7 | 28853 | 19 | |||
55832 | 233480 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1962 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008658.08091 | 2107023.31074 | 37.7659734109827 | -122.413283506344 | (37.7659734109827, -122.413283506344) | 8 | 4 | 7 | 28853 | 19 | |||
15538 | 233362 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006411.92043 | 2106982.43417 | 37.7657348109283 | -122.421049627935 | (37.7657348109283, -122.421049627935) | 8 | 4 | 7 | 28853 | 19 | |||
124358 | 87931 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008038 | 2106791 | 37.7653007068824 | -122.415411798097 | (37.7653007068824, -122.415411798097) | 8 | 4 | 7 | 28859 | 19 | ||
61050 | 38300 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
65592 | 38311 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 47228 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
114296 | 38316 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
124229 | 38308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
133308 | 38305 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
187382 | 38306 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
102670 | 98213 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
129967 | 98212 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
140574 | 98214 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
164430 | 98211 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
33577 | 38310 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2003 12:00:00 AM | Permit Number 47228 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
37442 | 87929 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
93220 | 87932 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
94761 | 87930 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
147631 | 38312 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2016 12:00:00 AM | 3 | Permit Number 771420 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | |
58069 | 233430 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2801 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008012.33322 | 2106763.12966 | 37.7652227387558 | -122.415498600376 | (37.7652227387558, -122.415498600376) | 8 | 4 | 7 | 28859 | 19 | |||
169947 | 233431 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2803 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007983.75701 | 2106759.69521 | 37.7652117022958 | -122.415597195761 | (37.7652117022958, -122.415597195761) | 8 | 4 | 7 | 28859 | 19 | |||
62514 | 233432 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2805 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007955.9785 | 2106758.25417 | 37.7652061840354 | -122.415693173211 | (37.7652061840354, -122.415693173211) | 8 | 4 | 7 | 28859 | 19 | |||
95271 | 233433 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007897.90504 | 2106755.67526 | 37.7651958382412 | -122.415893853325 | (37.7651958382412, -122.415893853325) | 8 | 4 | 7 | 28859 | 19 | |||
121618 | 233399 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.39498 | 2106706.34258 | 37.7650536626339 | -122.416303716638 | (37.7650536626339, -122.416303716638) | 8 | 4 | 7 | 28859 | 19 | |||
169625 | 233398 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007780.05383 | 2106672.69613 | 37.7649613705955 | -122.416295595781 | (37.7649613705955, -122.416295595781) | 8 | 4 | 7 | 28859 | 19 | |||
130437 | 233397 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007782.29383 | 2106638.7453 | 37.7648682754772 | -122.416285443329 | (37.7648682754772, -122.416285443329) | 8 | 4 | 7 | 28859 | 19 | |||
119013 | 233396 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007784.70136 | 2106598.65312 | 37.7647583270588 | -122.416274276453 | (37.7647583270588, -122.416274276453) | 8 | 4 | 7 | 28859 | 19 | |||
38583 | 233395 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007786.02518 | 2106562.96746 | 37.7646604169782 | -122.416267170006 | (37.7646604169782, -122.416267170006) | 8 | 4 | 7 | 28859 | 19 | |||
22493 | 233394 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007790.53489 | 2106496.52663 | 37.7644782394947 | -122.416246865994 | (37.7644782394947, -122.416246865994) | 8 | 4 | 7 | 28859 | 19 | |||
152499 | 233393 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007793.07408 | 2106462.86184 | 37.7643859465871 | -122.416235699112 | (37.7643859465871, -122.416235699112) | 8 | 4 | 7 | 28859 | 19 | |||
104215 | 233392 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007791.82881 | 2106445.05823 | 37.7643369919914 | -122.416238745127 | (37.7643369919914, -122.416238745127) | 8 | 4 | 7 | 28859 | 19 | |||
60569 | 66609 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.423125096713 | (37.7640893550041, -122.423125096713) | 8 | 4 | 5 | 28859 | 19 | |
32774 | 233361 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 28 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | 6005734.12152 | 2106385.89097 | 37.7640586131313 | -122.423351580335 | (37.7640586131313, -122.423351580335) | 8 | 4 | 5 | 28859 | 19 | ||
176128 | 233391 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 275 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007803.17814 | 2106268.28503 | 37.763852252016 | -122.416186970269 | (37.763852252016, -122.416186970269) | 8 | 4 | 7 | 28859 | 19 | |||
96556 | 76323 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2111 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1994 12:00:00 AM | 3 | 3x3 | 6008755.93357293 | 2106237.29701545 | 37.7638206919277 | -122.412889475083 | (37.7638206919277, -122.412889475083) | 8 | 4 | 7 | 28859 | 19 | ||
21704 | 233429 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2101 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008762.87625 | 2106190.29183 | 37.7636920162083 | -122.412862138879 | (37.7636920162083, -122.412862138879) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||
150663 | 91759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2100X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008715.935636 | 2106109.169361 | 37.7634666376506 | -122.413018756224 | (37.7634666376506, -122.413018756224) | 8 | 4 | 7 | 28859 | 19 | ||
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 | ||
149857 | 91824 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2151 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008766 | 2105886 | 37.7628566761401 | -122.412829820139 | (37.7628566761401, -122.412829820139) | 8 | 4 | 7 | 28859 | 19 | ||
123820 | 233428 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2147 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.0081 | 2105817.64626 | 37.7626700032421 | -122.412762703536 | (37.7626700032421, -122.412762703536) | 8 | 4 | 7 | 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 | ||
30722 | 91760 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
93946 | 91761 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
76805 | 91758 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008737.740026 | 2105649.554962 | 37.7622058660826 | -122.412910843759 | (37.7622058660826, -122.412910843759) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
128800 | 233449 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3210 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008043.39989 | 2105643.53791 | 37.7621503452727 | -122.415311884029 | (37.7621503452727, -122.415311884029) | 8 | 4 | 7 | 28859 | 19 | |||
190246 | 95637 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2196 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767403 | 6008103 | 2105638 | 37.7621384889596 | -122.415105357383 | (37.7621384889596, -122.415105357383) | 8 | 4 | 7 | 28859 | 19 | |
60057 | 233427 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6008800.67771 | 2105544.67026 | 37.761921409371 | -122.412685750365 | (37.761921409371, -122.412685750365) | 8 | 4 | 7 | 28859 | 19 | |||
3069 | 233426 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008801.72689 | 2105503.58115 | 37.7618086469759 | -122.412679216788 | (37.7618086469759, -122.412679216788) | 8 | 4 | 7 | 28859 | 19 | |||
123302 | 233425 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008802.53088 | 2105481.30644 | 37.7617475308496 | -122.412674861355 | (37.7617475308496, -122.412674861355) | 8 | 4 | 7 | 28859 | 19 | |||
97136 | 233479 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2180 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008744.74823 | 2105468.88661 | 37.7617101855999 | -122.41287383096 | (37.7617101855999, -122.41287383096) | 2 | 4 | 7 | 28859 | 19 | |||
108313 | 96526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
159351 | 96524 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
194076 | 96525 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
106410 | 57835 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1977 12:00:00 AM | 30 | 3x10 | Permit Number 16776 | 5996589.21937103 | 2105630.13222731 | 37.7614631235225 | -122.4549263227 | (37.7614631235225, -122.4549263227) | 15 | 5 | 11 | 29492 | 12 | |
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 | |||
91272 | 91757 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008781.413784 | 2104958.401867 | 37.7603105692892 | -122.412710929059 | (37.7603105692892, -122.412710929059) | 2 | 4 | 7 | 28859 | 19 | ||
5845 | 96500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
17099 | 96505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
21524 | 96504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
44113 | 96509 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
55022 | 96512 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
75897 | 96511 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
81818 | 96502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
88213 | 96513 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
124180 | 96506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
146063 | 96501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
189404 | 96510 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
177707 | 108436 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
129807 | 233368 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3505 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006128.23738 | 2104906.34475 | 37.7600183620686 | -122.421883341755 | (37.7600183620686, -122.421883341755) | 2 | 4 | 5 | 28859 | 19 | |||
79956 | 233364 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006470.82119 | 2104891.78129 | 37.7599976884594 | -122.420697473213 | (37.7599976884594, -122.420697473213) | 2 | 4 | 7 | 28859 | 19 | |||
174518 | 233478 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008776.66854 | 2104837.11683 | 37.7599772819377 | -122.41271876626 | (37.7599772819377, -122.41271876626) | 2 | 4 | 7 | 28859 | 19 | |||
69295 | 233424 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2339 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008842.98925 | 2104818.80994 | 37.7599307375328 | -122.412488100069 | (37.7599307375328, -122.412488100069) | 2 | 4 | 7 | 28859 | 19 | |||
159245 | 233477 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008779.60533 | 2104818.31587 | 37.7599258236246 | -122.412707280136 | (37.7599258236246, -122.412707280136) | 2 | 4 | 7 | 28859 | 19 | |||
150163 | 233365 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.17565 | 2104847.55108 | 37.7598763753088 | -122.420686190322 | (37.7598763753088, -122.420686190322) | 2 | 4 | 7 | 28859 | 19 | |||
119309 | 233476 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.53012 | 2104788.45028 | 37.7598440959392 | -122.412688136268 | (37.7598440959392, -122.412688136268) | 2 | 4 | 7 | 28859 | 19 | |||
86913 | 233475 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008784.35145 | 2104752.62578 | 37.7597457200079 | -122.412686221592 | (37.7597457200079, -122.412686221592) | 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) );