Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 10723 | 10723 | 1798 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.714056906280604 | -122.39967820720899 | (37.7140569062806, -122.399678207209) | ||
| 81891 | 81891 | 1801 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 97318 | 97318 | 1810 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | ||
| 101386 | 101386 | 1800 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 112272 | 112272 | 1797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2010 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6012333.445831 | 2088436.5537268997 | 37.7151437722719 | -122.399266207491 | (37.7151437722719, -122.399266207491) | |||
| 6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
| 13033 | 13033 | 15743 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | ||
| 12846 | 12846 | 15741 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.3059999999 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | ||
| 126919 | 126919 | 15464 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2434 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2000 12:00:00 AM | 12 | 4X4 | 6006931.67181 | 2104190.23259 | 37.7580973613707 | -122.41905384857 | (37.7580973613707, -122.41905384857) | ||
| 11995 | 11995 | 15738 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.725554668943204 | -122.434262847922 | (37.7255546689432, -122.434262847922) | ||
| 15971 | 15971 | 21858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.795940001 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | ||
| 62683 | 62683 | 33555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.4696400003 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | ||
| 65233 | 65233 | 33556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996225.02102 | 2110420.81163 | 37.774596191384 | -122.456532373263 | (37.774596191384, -122.456532373263) | ||
| 120058 | 120058 | 33554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996192.1418699995 | 2110415.99351 | 37.7745810743751 | -122.456645759522 | (37.7745810743751, -122.456645759522) | ||
| 181166 | 181166 | 33557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996239.10441 | 2110423.85984 | 37.774605369516394 | -122.456483876805 | (37.7746053695164, -122.456483876805) | ||
| 11493 | 11493 | 15784 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:53:00 PM | 3 | 3X3 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | ||
| 12396 | 12396 | 15742 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.725448291506204 | -122.43434171007601 | (37.7254482915062, -122.434341710076) | ||
| 87686 | 87686 | 82269 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 101862 | 101862 | 82273 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 127089 | 127089 | 82270 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 142615 | 142615 | 82272 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 144405 | 144405 | 82271 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3541 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.758505420616295 | -122.419971755856 | (37.7585054206163, -122.419971755856) | ||
| 160511 | 160511 | 33315 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 19 | Permit Number 37460 | 6005351.66292 | 2120593.2650099997 | 37.8030469569032 | -122.42568566546001 | (37.8030469569032, -122.42568566546) | |
| 54279 | 54279 | 33558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | |
| 4970 | 4970 | 253749 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5020 | 5020 | 253748 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 53512 | 53512 | 33314 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.803038340517396 | -122.425775331487 | (37.8030383405174, -122.425775331487) | |
| 39861 | 39861 | 65881 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) |
| 184973 | 184973 | 62210 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.821959999 | 2093620.4443599998 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) | |
| 110201 | 110201 | 32558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 138405 | 138405 | 32559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 145462 | 145462 | 32560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 18428 | 18428 | 25049 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.417330001 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | ||
| 17608 | 17608 | 15472 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2480 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006923.7988 | 2103940.4395 | 37.7574110439022 | -122.419063359319 | (37.7574110439022, -122.419063359319) | ||
| 22194 | 22194 | 15476 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2540 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006952.2887 | 2103573.3458 | 37.7564046935445 | -122.418938794072 | (37.7564046935445, -122.418938794072) | ||
| 119208 | 119208 | 94635 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3973 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53782 | 6003202.2 | 2104721.0 | 37.759343999852796 | -122.431989854822 | (37.7593439998528, -122.431989854822) | ||
| 110465 | 110465 | 49637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
| 139272 | 139272 | 51395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) |
| 139662 | 139662 | 51396 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
| 4287 | 4287 | 181059 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | ||
| 17338 | 17338 | 15450 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006934.5554 | 2104894.5299 | 37.760031361018 | -122.41909383171001 | (37.760031361018, -122.41909383171) | ||
| 17504 | 17504 | 15470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006982.3266 | 2104010.3832 | 37.757606388854605 | -122.418865906959 | (37.7576063888546, -122.418865906959) | ||
| 17576 | 17576 | 15453 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2365 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006954.2705 | 2104542.6911 | 37.7590664034557 | -122.41900069111901 | (37.7590664034557, -122.419000691119) | ||
| 17614 | 17614 | 15444 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006909.5324 | 2105286.5572 | 37.7611063676926 | -122.41920818332599 | (37.7611063676926, -122.419208183326) | ||
| 17702 | 17702 | 15454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006889.3715 | 2104582.8537 | 37.7591730259049 | -122.419227992101 | (37.7591730259049, -122.419227992101) | ||
| 20054 | 20054 | 15449 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2290 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006865.6984 | 2105042.6887 | 37.7604342928211 | -122.41934248602502 | (37.7604342928211, -122.419342486025) | ||
| 20059 | 20059 | 15488 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2659 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007044.505 | 2102886.6221 | 37.754524300175795 | -122.41857118207399 | (37.7545243001758, -122.418571182074) | ||
| 20301 | 20301 | 15438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006822.465 | 2105789.9059 | 37.762483542066704 | -122.419545024984 | (37.7624835420667, -122.419545024984) | ||
| 20606 | 20606 | 15451 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2337 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006940.6216 | 2104730.7429 | 37.7595819815227 | -122.419061234067 | (37.7595819815227, -122.419061234067) | ||
| 20945 | 20945 | 15473 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2501 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6007001.2834 | 2103755.6033 | 37.7569078893914 | -122.41878227799101 | (37.7569078893914, -122.418782277991) | ||
| 21205 | 21205 | 15439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.41953809802901 | (37.7624084411332, -122.419538098029) | ||
| 21432 | 21432 | 15474 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2515 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007000.5252 | 2103706.3156 | 37.756772514034 | -122.418781404781 | (37.756772514034, -122.418781404781) | ||
| 21610 | 21610 | 15437 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.762584363416295 | -122.419552616574 | (37.7625843634163, -122.419552616574) | ||
| 106919 | 106919 | 15440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2224 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006834.95821 | 2105372.78301 | 37.7613389236012 | -122.419472221327 | (37.7613389236012, -122.419472221327) | ||
| 24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
| 117641 | 117641 | 15428 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1994 12:00:00 AM | 18 | 3X3 | 6006867.61446 | 2106023.64726 | 37.7631278842618 | -122.419405452183 | (37.7631278842618, -122.419405452183) | ||
| 105688 | 105688 | 47457 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 107982 | 107982 | 47458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1307 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | ||
| 93041 | 93041 | 619 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3146 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 18 | 3x3 | 6008066.00463 | 2102184.1145200003 | 37.752652829489705 | -122.414988836945 | (37.7526528294897, -122.414988836945) | ||
| 115728 | 115728 | 474 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2790 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 12 | 3x3 | 6008872.67231 | 2102220.8769099996 | 37.752799067118396 | -122.412201825987 | (37.7527990671184, -122.412201825987) | ||
| 108446 | 108446 | 23052 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1065 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1992 12:00:00 AM | 15 | 4X4 | 6006449.25295 | 2103416.3322 | 37.7559452321174 | -122.420667325317 | (37.7559452321174, -122.420667325317) | ||
| 115534 | 115534 | 23054 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1081 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1992 12:00:00 AM | 12 | 4X4 | 6006403.948580001 | 2103302.7071 | 37.7556306904017 | -122.420815936586 | (37.7556306904017, -122.420815936586) | ||
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 105855 | 105855 | 667 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3297X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | ||
| 115639 | 115639 | 666 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3297X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | ||
| 19316 | 19316 | 15543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | ||
| 139224 | 139224 | 96035 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767674 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | |
| 18617 | 18617 | 48631 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 96328 | 96328 | 48632 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 140194 | 140194 | 48630 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.759965706466296 | -122.472500646803 | (37.7599657064663, -122.472500646803) | ||
| 50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
| 18216 | 18216 | 24604 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 6 | 3X3 | 6006726.6671 | 2107610.9661 | 37.7674783489788 | -122.420005592363 | (37.7674783489788, -122.420005592363) | ||
| 22272 | 22272 | 26854 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006727.5247 | 2107586.953 | 37.76741246299579 | -122.42000092176201 | (37.7674124629958, -122.420000921762) | ||
| 146258 | 146258 | 26855 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006730.055480001 | 2107572.9723799997 | 37.767374218099704 | -122.41999117588999 | (37.7673742180997, -122.41999117589) | ||
| 170194 | 170194 | 67454 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 18 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 24 | Permit Number 30963 | 5996314.7251699995 | 2112137.62024 | 37.7793152462196 | -122.456346235157 | (37.7793152462196, -122.456346235157) | ||
| 20065 | 20065 | 15349 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1906 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1993 12:00:00 AM | 12 | 4X4 | 6006754.9683 | 2107231.9019 | 37.7664391225711 | -122.419880800641 | (37.7664391225711, -122.419880800641) | ||
| 18777 | 18777 | 15489 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2663 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007048.2964 | 2102838.0926 | 37.754391262739205 | -122.41855462931801 | (37.7543912627392, -122.418554629318) | ||
| 22193 | 22193 | 15487 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2637 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007039.9554 | 2102983.6811 | 37.7547905457997 | -122.41859379809999 | (37.7547905457997, -122.4185937981) | ||
| 42753 | 42753 | 43930 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 81025 | 81025 | 43933 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 82678 | 82678 | 43932 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 110865 | 110865 | 43931 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
| 2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 2897 | 2897 | 253249 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 133518 | 133518 | 68285 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | |
| 10427 | 10427 | 28552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001308.3124 | 2090760.3284 | 37.7209037164668 | -122.437540063841 | (37.7209037164668, -122.437540063841) | ||
| 10432 | 10432 | 28549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4963 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000879.9631 | 2090072.8632 | 37.71899172902071 | -122.438971492831 | (37.7189917290207, -122.438971492831) | ||
| 10435 | 10435 | 28548 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5095 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000516.105 | 2089501.9034 | 37.7174032930481 | -122.440188283496 | (37.7174032930481, -122.440188283496) | ||
| 10447 | 10447 | 28554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4753 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001590.7646 | 2091209.3547 | 37.722152696500004 | -122.436595837081 | (37.7221526965, -122.436595837081) | ||
| 10497 | 10497 | 28546 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.716790788359795 | -122.440641159733 | (37.7167907883598, -122.440641159733) | ||
| 10709 | 10709 | 28542 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.44006317666401 | (37.7178909833984, -122.440063176664) | ||
| 10771 | 10771 | 28544 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5060 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000449.8979 | 2089508.0094 | 37.7174162891529 | -122.440417567822 | (37.7174162891529, -122.440417567822) | ||
| 10773 | 10773 | 28540 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4754 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001487.6438 | 2091153.5571 | 37.7219936282262 | -122.43694830738701 | (37.7219936282262, -122.436948307387) | ||
| 11001 | 11001 | 15823 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | ||
| 11110 | 11110 | 28537 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | ||
| 11123 | 11123 | 28555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | ||
| 11137 | 11137 | 28558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4667 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001923.346 | 2091737.9699 | 37.723623049111296 | -122.435483982262 | (37.7236230491113, -122.435483982262) |
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");