Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601 | 601 | 225172 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2002 12:00:00 AM | 9 | Width 3ft | Permit Number 46150 | 6006535.621280001 | 2098220.1400900004 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | |
| 10585 | 10585 | 27651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2700 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982420.6256 | 2096461.5972 | 37.73546591249 | -122.503249937577 | (37.73546591249, -122.503249937577) | ||
| 10607 | 10607 | 27653 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2900X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981776.6997 | 2096484.8387 | 37.7354918543068 | -122.505477915571 | (37.7354918543068, -122.505477915571) | ||
| 11897 | 11897 | 27649 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982997.5613 | 2096369.9984 | 37.7352483041994 | -122.501248513045 | (37.7352483041994, -122.501248513045) | ||
| 12298 | 12298 | 27647 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 5983545.7870000005 | 2096052.8205 | 37.7344095981993 | -122.499329695326 | (37.7344095981993, -122.499329695326) | |||
| 17649 | 17649 | 30005 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 795X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005615.08127 | 2098546.14287 | 37.7425257613504 | -122.423205996259 | (37.7425257613504, -122.423205996259) | ||
| 19207 | 19207 | 546 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2884 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009527.2979999995 | 2102212.4790000003 | 37.752812718682996 | -122.409937408543 | (37.752812718683, -122.409937408543) | |||
| 19514 | 19514 | 16309 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997384.824659999 | 2094713.0859599998 | 37.7315332040811 | -122.45138725623801 | (37.7315332040811, -122.451387256238) | ||
| 19536 | 19536 | 29706 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005915.3087 | 2099718.0441099997 | 37.745760475271204 | -122.422251139273 | (37.7457604752712, -122.422251139273) | |||
| 19777 | 19777 | 16245 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997958.54401 | 2094705.63588 | 37.7315455832604 | -122.44940326996401 | (37.7315455832604, -122.449403269964) | ||
| 24138 | 24138 | 225161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2957 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009038.45977 | 2101249.93986 | 37.7501423922716 | -122.411559907065 | (37.7501423922716, -122.411559907065) | |||
| 25803 | 25803 | 225170 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009137.3737 | 2096981.67824 | 37.7384282324737 | -122.410916429557 | (37.7384282324737, -122.410916429557) | |||
| 29299 | 29299 | 225151 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 14 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007510.1037 | 2099736.8177900002 | 37.7459018513879 | -122.416737884151 | (37.7459018513879, -122.416737884151) | |||
| 34064 | 34064 | 126015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009674.03362 | 2115055.86699 | 37.788085909974605 | -122.410336729273 | (37.7880859099746, -122.410336729273) | |||
| 34445 | 34445 | 189999 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Carolina St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6012378.8382 | 2104615.7006200003 | 37.759570841431604 | -122.400244972539 | (37.7595708414316, -122.400244972539) | |||
| 37175 | 37175 | 126019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 542 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6009096.37686 | 2114637.77725 | 37.7869055381056 | -122.412305766101 | (37.7869055381056, -122.412305766101) | |||
| 38579 | 38579 | 190011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1599 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6014210.748430001 | 2095415.1555299999 | 37.7344100624646 | -122.39326543937 | (37.7344100624646, -122.39326543937) | |||
| 42492 | 42492 | 247161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2399 Market St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 5ft | 6002372.95372 | 2105936.54637 | 37.7626345492748 | -122.43494472103998 | (37.7626345492748, -122.43494472104) | |||
| 43790 | 43790 | 100327 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6013441.178619999 | 2111631.13985 | 37.7788928511631 | -122.39706274847299 | (37.7788928511631, -122.397062748473) | |||
| 44503 | 44503 | 225169 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 225 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008644.12934 | 2097539.28369 | 37.7399316246566 | -122.412661242936 | (37.7399316246566, -122.412661242936) | |||
| 45931 | 45931 | 190000 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 770 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6012104.84568 | 2104756.14819 | 37.7599411975544 | -122.401202450128 | (37.7599411975544, -122.401202450128) | |||
| 47236 | 47236 | 225176 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1020 Alabama St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6009156.40291 | 2103118.80305 | 37.7552804871291 | -122.411284056222 | (37.7552804871291, -122.411284056222) | |||
| 49897 | 49897 | 225168 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4400 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000595.27715 | 2101716.78753 | 37.750947025601 | -122.44079033950399 | (37.750947025601, -122.440790339504) | |||
| 50903 | 50903 | 225174 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1000 Jarboe Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6009367.84971 | 2096849.47647 | 37.738078156068894 | -122.410110221514 | (37.7380781560689, -122.410110221514) | |||
| 54322 | 54322 | 206026 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5994921.599769999 | 2093400.11628 | 37.727786752547296 | -122.45980797188601 | (37.7277867525473, -122.459807971886) | |||
| 57727 | 57727 | 117702 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5983001.87469 | 2113075.50324 | 37.781117159673705 | -122.50246961447901 | (37.7811171596737, -122.502469614479) | |||
| 58330 | 58330 | 206036 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996259.37903 | 2091732.03952 | 37.7232834540474 | -122.455062785437 | (37.7232834540474, -122.455062785437) | |||
| 65401 | 65401 | 190004 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1745 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 6012733.96255 | 2104688.60274 | 37.7597908102085 | -122.399021884672 | (37.7597908102085, -122.399021884672) | |||
| 66694 | 66694 | 225148 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1199 Capp St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6007231.69522 | 2100624.49408 | 37.7483235475968 | -122.417763493512 | (37.7483235475968, -122.417763493512) | |||
| 70063 | 70063 | 225186 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 252 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007150.88723 | 2105850.08612 | 37.762667276482894 | -122.418413397566 | (37.7626672764829, -122.418413397566) | |||
| 71331 | 71331 | 225208 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003395.5499 | 2104500.55449 | 37.758749668692495 | -122.431305421031 | (37.7587496686925, -122.431305421031) | |||
| 72634 | 72634 | 225193 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2973 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009010.89225 | 2102726.9922700003 | 37.7541965009837 | -122.41175959345 | (37.7541965009837, -122.41175959345) | |||
| 73909 | 73909 | 225153 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 105 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010058.65262 | 2099813.08608 | 37.7462542804284 | -122.407930691168 | (37.7462542804284, -122.407930691168) | |||
| 74897 | 74897 | 206045 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 260 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992364.28925 | 2095097.86508 | 37.732300949933 | -122.468772052499 | (37.732300949933, -122.468772052499) | |||
| 75852 | 75852 | 225160 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3191 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007035.27064 | 2103785.32086 | 37.756991400544294 | -122.418666844507 | (37.7569914005443, -122.418666844507) | |||
| 78812 | 78812 | 27652 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2830 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982048.7143342 | 2096528.9941474 | 37.7356290969828 | -122.50454074467 | (37.7356290969828, -122.50454074467) | ||
| 79507 | 79507 | 27654 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2968 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981673.036337901 | 2096540.7284095 | 37.7356392111548 | -122.50584045491001 | (37.7356392111548, -122.50584045491) | ||
| 97575 | 97575 | 27646 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2260 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5983743.832098301 | 2096000.4658733997 | 37.7342774634165 | -122.498641133162 | (37.7342774634165, -122.498641133162) | ||
| 106072 | 106072 | 27650 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2650 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982609.4890242005 | 2096515.7957863999 | 37.735625827225796 | -122.502600986809 | (37.7356258272258, -122.502600986809) | ||
| 109054 | 109054 | 225205 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3993 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003915.45765 | 2101274.6592 | 37.749921570934895 | -122.429277312204 | (37.7499215709349, -122.429277312204) | |||
| 131158 | 131158 | 225165 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001787.26659 | 2100614.3133 | 37.7479877056879 | -122.436589428169 | (37.7479877056879, -122.436589428169) | |||
| 132078 | 132078 | 225152 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 339 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006495.85243 | 2097173.79313 | 37.738807262551205 | -122.42006317417801 | (37.7388072625512, -122.420063174178) | |||
| 134896 | 134896 | 120285 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 151 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988326.80885 | 2115016.043 | 37.7867567842415 | -122.484190580999 | (37.7867567842415, -122.484190580999) | ||||
| 137612 | 137612 | 116891 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2798X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999182.98236 | 2118335.47511 | 37.796497168372795 | -122.446869879744 | (37.7964971683728, -122.446869879744) | |||
| 143088 | 143088 | 27648 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2400 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5983342.3231549 | 2096264.1854035999 | 37.7349780102042 | -122.50004874464199 | (37.7349780102042, -122.500048744642) | ||
| 148722 | 148722 | 225150 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 21 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007236.93234 | 2099402.00378 | 37.744967159016596 | -122.417658748554 | (37.7449671590166, -122.417658748554) | |||
| 149483 | 149483 | 225211 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 83 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6006284.028469999 | 2099592.34977 | 37.74543613838021 | -122.42096723475402 | (37.7454361383802, -122.420967234754) | |||
| 150087 | 150087 | 225171 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006678.67564 | 2099088.45084 | 37.7440747833339 | -122.419566860849 | (37.7440747833339, -122.419566860849) | |||
| 150193 | 150193 | 206044 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 275 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991926.36894 | 2090353.75557 | 37.7192494901497 | -122.46994073500099 | (37.7192494901497, -122.469940735001) | |||
| 150411 | 150411 | 225204 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 423 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003555.12848 | 2103300.5441900003 | 37.7554637680609 | -122.430667894334 | (37.7554637680609, -122.430667894334) | |||
| 150545 | 150545 | 225149 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008818.14298 | 2097106.89478 | 37.7387541440918 | -122.41202902491999 | (37.7387541440918, -122.41202902492) | |||
| 152589 | 152589 | 32693 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3732 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37102 | 6004859.3884 | 2102538.49197 | 37.7534451551954 | -122.42610311279199 | (37.7534451551954, -122.426103112792) | ||
| 152776 | 152776 | 225194 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007219.63733 | 2103836.19178 | 37.757141458734395 | -122.418032839538 | (37.7571414587344, -122.418032839538) | |||
| 154165 | 154165 | 246301 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3998 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6002344.4551 | 2105927.1578 | 37.7626071523851 | -122.435042615882 | (37.7626071523851, -122.435042615882) | |||
| 154762 | 154762 | 190008 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013001.004319999 | 2104770.77292 | 37.7600313087249 | -122.39810407704901 | (37.7600313087249, -122.398104077049) | |||
| 157709 | 157709 | 225159 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3189 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007127.86585 | 2103790.91823 | 37.75701198242339 | -122.41834701140301 | (37.7570119824234, -122.418347011403) | |||
| 159626 | 159626 | 206047 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 575 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997894.62452 | 2097851.39191 | 37.7401794193521 | -122.449850874237 | (37.7401794193521, -122.449850874237) | |||
| 160931 | 160931 | 126014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2322 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5999611.42315 | 2120546.01877 | 37.8025911966964 | -122.445546423945 | (37.8025911966964, -122.445546423945) | |||
| 166960 | 166960 | 126011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 5999243.15513 | 2117721.3039700002 | 37.7948142553315 | -122.446617458939 | (37.7948142553315, -122.446617458939) | |||
| 170506 | 170506 | 225177 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 858 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007943.221609999 | 2102943.9382 | 37.754732232531794 | -122.41546723204901 | (37.7547322325318, -122.415467232049) | |||
| 171539 | 171539 | 190001 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012095.84153 | 2104748.83564 | 37.759920616576 | -122.401233077439 | (37.759920616576, -122.401233077439) | ||||
| 172815 | 172815 | 225154 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6010002.80385 | 2099859.8218 | 37.7463794795488 | -122.40812710578999 | (37.7463794795488, -122.40812710579) | |||
| 174222 | 174222 | 190012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 6ft | 6012453.688019999 | 2108575.49646 | 37.770447730615295 | -122.400264221637 | (37.7704477306153, -122.400264221637) | |||
| 176416 | 176416 | 225206 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3816 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004315.95235 | 2101927.5657 | 37.751736964897106 | -122.427938900685 | (37.7517369648971, -122.427938900685) | |||
| 176830 | 176830 | 225187 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007244.27543 | 2104007.62921 | 37.7576135731224 | -122.417959784028 | (37.7576135731224, -122.417959784028) | |||
| 177844 | 177844 | 190013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 8ft | 6012319.46536 | 2108768.17498 | 37.7709692969125 | -122.40074203953002 | (37.7709692969125, -122.40074203953) | |||
| 181029 | 181029 | 126020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009058.631990001 | 2114632.0881 | 37.786887798972295 | -122.412435952882 | (37.7868877989723, -122.412435952882) | |||
| 181288 | 181288 | 225164 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2861 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007651.46889 | 2106744.64503 | 37.7651516941295 | -122.416745437549 | (37.7651516941295, -122.416745437549) | |||
| 182331 | 182331 | 225163 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2859 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007679.26286 | 2106746.83875 | 37.7651592807999 | -122.416649460099 | (37.7651592807999, -122.416649460099) | |||
| 187574 | 187574 | 31676 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770730 | 6001735.33868 | 2121814.4309799997 | 37.806194943810894 | -122.438287548749 | (37.8061949438109, -122.438287548749) | |||
| 188409 | 188409 | 126023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 560 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009008.4198 | 2114630.0994700002 | 37.7868795207321 | -122.412609535497 | (37.7868795207321, -122.412609535497) | |||
| 17622 | 17622 | 638 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007578.42744 | 2102058.8333799997 | 37.752281425265295 | -122.41666609486401 | (37.7522814252653, -122.416666094864) | ||
| 17832 | 17832 | 16310 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997364.820830001 | 2094712.7517799998 | 37.7315311410332 | -122.45145638890499 | (37.7315311410332, -122.451456388905) | ||
| 19578 | 19578 | 29700 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005880.5001300005 | 2100335.27269 | 37.747453280849 | -122.422415350984 | (37.747453280849, -122.422415350984) | |||
| 20337 | 20337 | 29707 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005916.90216 | 2099727.1189900003 | 37.74578548271 | -122.422246273943 | (37.74578548271, -122.422246273943) | |||
| 20510 | 20510 | 16215 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998684.93347 | 2094693.5890400002 | 37.7315540305774 | -122.446891144221 | (37.7315540305774, -122.446891144221) | ||
| 21427 | 21427 | 16246 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997938.93286 | 2094706.04445 | 37.731545583255 | -122.44947109863001 | (37.731545583255, -122.44947109863) | ||
| 21753 | 21753 | 7651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3309 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008514.76673 | 2099315.4507400002 | 37.7448013267216 | -122.413234094881 | (37.7448013267216, -122.413234094881) | |||
| 27211 | 27211 | 190009 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.6424 | 2104780.97852 | 37.7600593109036 | -122.39810604475099 | (37.7600593109036, -122.398106044751) | |||
| 27326 | 27326 | 190005 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012982.63799 | 2103818.56401 | 37.757415728567295 | -122.398100794529 | (37.7574157285673, -122.398100794529) | ||||
| 27419 | 27419 | 190015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015573.49943 | 2107841.28907 | 37.768605228364 | -122.38942140686899 | (37.768605228364, -122.389421406869) | |||
| 27590 | 27590 | 225203 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005899.22105 | 2100030.8366400003 | 37.746618424914296 | -122.422328988218 | (37.7466184249143, -122.422328988218) | |||
| 31524 | 31524 | 175845 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 98 Newton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000912.9484 | 2087984.8955700002 | 37.7132605143345 | -122.43870794134399 | (37.7132605143345, -122.438707941344) | |||
| 37075 | 37075 | 225178 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 858 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007945.63288 | 2102930.5151400003 | 37.754695511392605 | -122.41545794294301 | (37.7546955113926, -122.415457942943) | |||
| 39929 | 39929 | 225188 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007247.90987 | 2103966.5437 | 37.757500966319604 | -122.417944302192 | (37.7575009663196, -122.417944302192) | |||
| 45626 | 45626 | 186972 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5982510.8573 | 2096452.0272 | 37.7354449395599 | -122.50293726958999 | (37.7354449395599, -122.50293726959) | |||
| 49570 | 49570 | 225173 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 98 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006194.79816 | 2097580.2396 | 37.7399063069243 | -122.42113293303998 | (37.7399063069243, -122.42113293304) | |||
| 52213 | 52213 | 190002 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012104.02513 | 2104748.44893 | 37.759920011313206 | -122.401204746997 | (37.7599200113132, -122.401204746997) | ||||
| 57244 | 57244 | 126010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 85 Toledo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001465.00623 | 2119940.72568 | 37.801034867711 | -122.43908870440599 | (37.801034867711, -122.439088704406) | |||
| 57603 | 57603 | 100328 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6013422.40904 | 2111650.3481099997 | 37.778944547796705 | -122.397129027591 | (37.7789445477967, -122.397129027591) | |||
| 57805 | 57805 | 206027 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5994921.23721 | 2093409.63408 | 37.7278128652723 | -122.459809914392 | (37.7278128652723, -122.459809914392) | |||
| 63388 | 63388 | 225185 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007746.072980001 | 2106673.2030700003 | 37.764960851679 | -122.41641316324 | (37.764960851679, -122.41641316324) | |||
| 66360 | 66360 | 190027 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015553.64576 | 2108193.7384099998 | 37.7695718763733 | -122.389514697159 | (37.7695718763733, -122.389514697159) | |||
| 67868 | 67868 | 206024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991156.52884 | 2106111.8053099997 | 37.7624725256075 | -122.473750702041 | (37.7624725256075, -122.473750702041) | |||
| 70642 | 70642 | 206037 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996260.563569999 | 2091771.26312 | 37.72339122070879 | -122.45506152367201 | (37.7233912207088, -122.455061523672) | |||
| 71985 | 71985 | 190021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015535.23888 | 2108524.8420599997 | 37.7704799937881 | -122.389601494338 | (37.7704799937881, -122.389601494338) | |||
| 97571 | 97571 | 225162 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2859 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007695.93122 | 2106747.75341 | 37.765162729690296 | -122.41659187291701 | (37.7651627296903, -122.416591872917) | |||
| 146563 | 146563 | 225195 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007206.11976 | 2103835.7790900003 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | |||
| 147063 | 147063 | 189996 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012291.07861 | 2105130.95435 | 37.7609807203027 | -122.400584686038 | (37.7609807203027, -122.400584686038) | |||
| 147217 | 147217 | 186971 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5983094.6287 | 2096334.4526 | 37.7351564048044 | -122.50091029299801 | (37.7351564048044, -122.500910292998) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");