Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99 | 99 | 7992 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2247 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2007 12:00:00 AM | 3 | 3X3 | 6005467.69382 | 2117725.44397 | 37.7951792074025 | -122.42507996488001 | (37.7951792074025, -122.42507996488) | ||
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 906 | 906 | 238924 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1362 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777634 | 6007680.96975 | 2101719.66165 | 37.751355903252 | -122.41628746589 | (37.751355903252, -122.41628746589) | |
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 1422 | 1422 | 196745 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1201X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45465 | 6012738.02923 | 2107105.72844 | 37.7664279283277 | -122.399177491654 | (37.7664279283277, -122.399177491654) | |
| 1488 | 1488 | 28091 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 550 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 3x3 | 6001688.8969 | 2110354.8179 | 37.7747271663388 | -122.437627056778 | (37.7747271663388, -122.437627056778) | ||
| 2197 | 2197 | 24571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2252 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002831.271980001 | 2116073.36845 | 37.7904937512412 | -122.434084229923 | (37.7904937512412, -122.434084229923) | ||
| 3211 | 3211 | 239952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 5 | Width 3ft | Permit Number 42822 | 6008805.731790001 | 2103926.75101 | 37.7574792557704 | -122.412553896246 | (37.7574792557704, -122.412553896246) | |
| 3651 | 3651 | 240097 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 114 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 7 | Width 3ft | Permit Number 31402 | 6002724.24367 | 2107408.57095 | 37.766696310316796 | -122.433834955823 | (37.7666963103168, -122.433834955823) | |
| 3877 | 3877 | 38690 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1529 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2013 12:00:00 AM | 8 | 6x5 | Permit Number 40603 | 6000458.9819 | 2110614.4446 | 37.7753700290705 | -122.441900209231 | (37.7753700290705, -122.441900209231) |
| 4410 | 4410 | 24569 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2325 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2001 12:00:00 AM | 4 | 3X3 | 6002751.62684 | 2116304.73966 | 37.7911245168302 | -122.43437634589199 | (37.7911245168302, -122.434376345892) | ||
| 4599 | 4599 | 100201 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 255 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51875 | 6008346.927130001 | 2112747.04212 | 37.7816719523255 | -122.414764839028 | (37.7816719523255, -122.414764839028) | ||
| 4739 | 4739 | 3036 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2607 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X2 | 6001811.8813 | 2115314.7838 | 37.7883529667295 | -122.437556903926 | (37.7883529667295, -122.437556903926) | |||
| 6007 | 6007 | 28723 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003233.5773 | 2114519.7036 | 37.7862506062504 | -122.43258125527099 | (37.7862506062504, -122.432581255271) | |||
| 6272 | 6272 | 41118 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1831 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 10 | 3x6 | Permit Number 41864 | 5998988.6196 | 2110750.7439 | 37.7756603770461 | -122.44699632592899 | (37.7756603770461, -122.446996325929) | |
| 6389 | 6389 | 65428 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 720 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1989 12:00:00 AM | 8 | 3x3 | Permit Number 28287 | 6010438.53437 | 2116215.60904 | 37.791313109171206 | -122.40777348606899 | (37.7913131091712, -122.407773486069) | |
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7371 | 7371 | 44106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1242 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778937 | 6007599.34177 | 2118533.61268 | 37.797518421388205 | -122.41776142416401 | (37.7975184213882, -122.417761424164) | |
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 8349 | 8349 | 30526 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 60 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1995 12:00:00 AM | 10 | 3x3 | 6008665.53874 | 2112580.6235700003 | 37.7812329033191 | -122.413650815535 | (37.7812329033191, -122.413650815535) | ||
| 8402 | 8402 | 43083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 220 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51045 | 6009044.65676 | 2113355.74904 | 37.783382494344 | -122.412394054366 | (37.783382494344, -122.412394054366) | |
| 8461 | 8461 | 28724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003220.1851 | 2114518.78 | 37.7862473108086 | -122.432627522769 | (37.7862473108086, -122.432627522769) | |||
| 8466 | 8466 | 59594 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1447 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | 3x3 | Permit Number 18991 | 6000147.142999999 | 2113940.7254 | 37.7844853693895 | -122.44321788363199 | (37.7844853693895, -122.443217883632) | |
| 9118 | 9118 | 24139 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 120X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9356 | 9356 | 5932 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1355 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6004005.8425 | 2112845.6747 | 37.781697906038 | -122.429789972847 | (37.781697906038, -122.429789972847) | |||
| 9366 | 9366 | 24140 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 120X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9425 | 9425 | 24116 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 180X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | 3 | 3X3 | 6016348.1117358 | 2095906.4833443002 | 37.735877662010296 | -122.38591004253 | (37.7358776620103, -122.38591004253) | ||
| 9745 | 9745 | 47282 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45227 | 6010345.86300325 | 2101091.40389861 | 37.7497803366023 | -122.407027634693 | (37.7497803366023, -122.407027634693) | |
| 10268 | 10268 | 49966 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2003 12:00:00 AM | Permit Number 46718 | 6000426.47543442 | 2105220.01428839 | 37.7605564179186 | -122.44162544737301 | (37.7605564179186, -122.441625447373) | |||
| 11740 | 11740 | 108556 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) |
| 13355 | 13355 | 22260 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4636 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1996 12:00:00 AM | 6 | 3x3 | 6015027.458 | 2095928.9019999998 | 37.7358660451645 | -122.390477668904 | (37.7358660451645, -122.390477668904) | ||
| 13363 | 13363 | 91696 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1699 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007461.4288800005 | 2108586.23099 | 37.770197566194504 | -122.41753327153799 | (37.7701975661945, -122.417533271538) | ||
| 13365 | 13365 | 22227 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 3 | 3x3 | 6015350.6152 | 2096709.0679 | 37.7380261434859 | -122.38941484248998 | (37.7380261434859, -122.38941484249) | ||
| 13370 | 13370 | 84837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 13X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 2x3 | Permit No. 49303 | 6010462.24216 | 2111775.7288599997 | 37.779123579430106 | -122.407378318556 | (37.7791235794301, -122.407378318556) | |
| 13434 | 13434 | 22229 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015364.7865 | 2096754.4159 | 37.73815144552721 | -122.38936901073099 | (37.7381514455272, -122.389369010731) | |||
| 13506 | 13506 | 22236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015297.7091 | 2096577.2751 | 37.737661333943 | -122.389588564769 | (37.737661333943, -122.389588564769) | |||
| 13551 | 13551 | 22289 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4836 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3X3 | 6014859.2794 | 2095367.428 | 37.734315020944 | -122.39101990239901 | (37.734315020944, -122.391019902399) | ||
| 13619 | 13619 | 22307 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014686.8832 | 2094799.1002 | 37.7327449405845 | -122.391576215676 | (37.7327449405845, -122.391576215676) | ||||
| 13668 | 13668 | 24300 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 10 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016267.21973 | 2096044.36505 | 37.736251780486604 | -122.386199330252 | (37.7362517804866, -122.386199330252) | ||
| 13672 | 13672 | 22228 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015357.7009 | 2096730.7972 | 37.7380862005585 | -122.38939186050399 | (37.7380862005585, -122.389391860504) | |||
| 13695 | 13695 | 22311 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014675.8119 | 2094762.1958 | 37.7326429940585 | -122.391611912964 | (37.7326429940585, -122.391611912964) | |||
| 13871 | 13871 | 95055 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5100X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014636.9706 | 2094632.7306 | 37.7322853528356 | -122.39173714895 | (37.7322853528356, -122.39173714895) | |||
| 13950 | 13950 | 22303 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5012X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014706.917 | 2094874.4907 | 37.7329530595777 | -122.391512222074 | (37.7329530595777, -122.391512222074) | |||
| 14054 | 14054 | 95063 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4911 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014862.0973 | 2095159.3952 | 37.7337439615305 | -122.39099562481701 | (37.7337439615305, -122.390995624817) | |||
| 14123 | 14123 | 22273 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4726 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014961.0301 | 2095699.0403 | 37.735231206510704 | -122.390691280263 | (37.7352312065107, -122.390691280263) | |||
| 14265 | 14265 | 22256 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4622 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1995 12:00:00 AM | 6 | 3x3 | 6015042.2198 | 2095979.5138 | 37.7360058337427 | -122.390430166333 | (37.7360058337427, -122.390430166333) | ||
| 14392 | 14392 | 22293 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4910 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014812.3581 | 2095203.9942 | 37.733863661185495 | -122.39117070574301 | (37.7338636611855, -122.391170705743) | |||
| 14394 | 14394 | 24301 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 14 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016327.55349 | 2096048.14928 | 37.7362655104391 | -122.385990993297 | (37.7362655104391, -122.385990993297) | |||
| 14396 | 14396 | 92868 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014891.438999999 | 2095469.7059 | 37.7345976397448 | -122.39091586114999 | (37.7345976397448, -122.39091586115) | |||
| 14543 | 14543 | 22318 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5122 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3x3 | 6014602.7867 | 2094516.4656 | 37.73196421508489 | -122.39184720465799 | (37.7319642150849, -122.391847204658) | ||
| 14591 | 14591 | 22321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5135 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014664.7848 | 2094477.5071 | 37.7318606845446 | -122.39163013942499 | (37.7318606845446, -122.391630139425) | |||
| 14725 | 14725 | 22226 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4342 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1999 12:00:00 AM | 12 | 3X3 | 6015299.3625 | 2096815.5886 | 37.7383157858175 | -122.389599487386 | (37.7383157858175, -122.389599487386) | ||
| 14827 | 14827 | 22296 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4920 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014793.9059 | 2095156.0185 | 37.7337309056506 | -122.391231148662 | (37.7337309056506, -122.391231148662) | |||
| 14874 | 14874 | 22298 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014820.3268 | 2095023.3662 | 37.73336813561429 | -122.391130534135 | (37.7333681356143, -122.391130534135) | |||
| 14891 | 14891 | 22225 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4342 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 12 | 3x3 | 6015302.1967 | 2096838.735 | 37.7383794982525 | -122.389591304141 | (37.7383794982525, -122.389591304141) | ||
| 14900 | 14900 | 42231 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42486 | 6010159.8373 | 2112236.08642 | 37.780370682809 | -122.408456946549 | (37.780370682809, -122.408456946549) | |
| 14958 | 14958 | 95062 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014835.7159 | 2095070.6328 | 37.7334987740836 | -122.39108063188101 | (37.7334987740836, -122.391080631881) | |||
| 15079 | 15079 | 42230 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | 5x3 | Permit Number 42486 | 6010185.283980001 | 2112260.71785 | 37.7804397399325 | -122.408370652088 | (37.7804397399325, -122.408370652088) |
| 15092 | 15092 | 22219 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4301 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 6 | 3x3 | 6015377.5406 | 2096805.4325 | 37.7382922337956 | -122.389328474573 | (37.7382922337956, -122.389328474573) | ||
| 15130 | 15130 | 22319 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5131 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014671.3256 | 2094492.551 | 37.731902355110996 | -122.391608577745 | (37.731902355111, -122.391608577745) | |||
| 15140 | 15140 | 95292 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4508 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015152.932999999 | 2096346.9761 | 37.7370209512786 | -122.39007304552901 | (37.7370209512786, -122.390073045529) | |||
| 15201 | 15201 | 22305 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5024 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014702.6993 | 2094852.8752 | 37.7328934737014 | -122.39152529321899 | (37.7328934737014, -122.391525293219) | |||
| 15221 | 15221 | 22244 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4445 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015258.502 | 2096439.8138 | 37.737281719223496 | -122.38971452537201 | (37.7372817192235, -122.389714525372) | |||
| 15265 | 15265 | 22253 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4546 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015116.5558 | 2096227.8276 | 37.736691776177295 | -122.390190497304 | (37.7366917761773, -122.390190497304) | ||
| 15273 | 15273 | 22220 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4301 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015388.4053 | 2096841.333 | 37.7383914115765 | -122.389293415685 | (37.7383914115765, -122.389293415685) | |||
| 15371 | 15371 | 22310 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014681.6111 | 2094780.648 | 37.7326939819519 | -122.391593153167 | (37.7326939819519, -122.391593153167) | |||
| 15378 | 15378 | 22297 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2001 12:00:00 AM | 3 | 3x3 | 6014819.7772 | 2094987.0918 | 37.7332685029776 | -122.391129899656 | (37.7332685029776, -122.391129899656) | ||
| 15417 | 15417 | 22246 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4445 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015268.8942 | 2096480.9105 | 37.7373951386403 | -122.38968146396002 | (37.7373951386403, -122.38968146396) | |||
| 15443 | 15443 | 22230 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015369.9826 | 2096775.2005 | 37.7382088038746 | -122.38935249607401 | (37.7382088038746, -122.389352496074) | |||
| 15465 | 15465 | 22290 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4850 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014853.4802 | 2095344.2309 | 37.7342510046252 | -122.391038331468 | (37.7342510046252, -122.391038331468) | ||||
| 15475 | 15475 | 22302 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5005 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6014777.2871 | 2094864.0702 | 37.732928352623 | -122.391268204226 | (37.732928352623, -122.391268204226) | |||
| 15533 | 15533 | 22271 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4720 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1995 12:00:00 AM | 6 | 3x3 | 6014966.8294 | 2095722.7646 | 37.735296670354295 | -122.390672887136 | (37.7352966703543, -122.390672887136) | ||
| 15635 | 15635 | 22233 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4400X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015237.9536 | 2096632.7792 | 37.737810423344996 | -122.389799045633 | (37.737810423345, -122.389799045633) | |||
| 15682 | 15682 | 92867 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53082 | 6014898.2926 | 2095492.3757 | 37.7346602666874 | -122.390893749601 | (37.7346602666874, -122.390893749601) | |
| 15701 | 15701 | 95056 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5100 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014630.0146 | 2094610.4713 | 37.7322238471755 | -122.39175964179701 | (37.7322238471755, -122.391759641797) | |||
| 15716 | 15716 | 22235 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4410 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015225.6719 | 2096592.1549 | 37.737698196233794 | -122.38983867300301 | (37.7376981962338, -122.389838673003) | |||
| 15741 | 15741 | 84839 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 13X Harriet St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49303 | 6010429.20805 | 2111813.3182099997 | 37.7792249420059 | -122.40749524841999 | (37.7792249420059, -122.40749524842) | |
| 15816 | 15816 | 84838 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 13X Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49303 | 6010446.83177 | 2111795.3152099997 | 37.7791764964284 | -122.407433010849 | (37.7791764964284, -122.407433010849) | |
| 15870 | 15870 | 22286 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4820 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1999 12:00:00 AM | 3 | 3X3 | 6014883.0037 | 2095444.9272 | 37.7345291344217 | -122.390943293827 | (37.7345291344217, -122.390943293827) | ||
| 16077 | 16077 | 22245 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4445 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015261.8086 | 2096457.764 | 37.7373311901678 | -122.389704346197 | (37.7373311901678, -122.389704346197) | |||
| 16166 | 16166 | 95061 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5019 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014762.2432 | 2094820.2467 | 37.732807187274105 | -122.391317152917 | (37.7328071872741, -122.391317152917) | |||
| 16184 | 16184 | 22254 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4602 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015071.7433 | 2096082.3189 | 37.7362897533029 | -122.39033527146499 | (37.7362897533029, -122.390335271465) | |||
| 16246 | 16246 | 85552 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 320 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008325.98929 | 2108714.16712 | 37.7705974578492 | -122.414551808542 | (37.7705974578492, -122.414551808542) | |||
| 16289 | 16289 | 22301 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5012X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014715.8795 | 2094899.7965 | 37.733023041622204 | -122.391483004656 | (37.7330230416222, -122.391483004656) | |||
| 16328 | 16328 | 22259 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4636 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1996 12:00:00 AM | 6 | 3x3 | 6015032.7301 | 2095944.7182 | 37.7359097656913 | -122.390460545797 | (37.7359097656913, -122.390460545797) | ||
| 16436 | 16436 | 22232 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4342 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1997 12:00:00 AM | 4 | 3x3 | 6015306.4481 | 2096851.4891 | 37.7384147541361 | -122.38957749525 | (37.7384147541361, -122.38957749525) | ||
| 16491 | 16491 | 95057 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5112 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014622.8598 | 2094584.2372 | 37.7321514164802 | -122.391782544083 | (37.7321514164802, -122.391782544083) | |||
| 16546 | 16546 | 24302 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 15 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2007 12:00:00 AM | 3 | 3X3 | 6016323.370209999 | 2096080.15892 | 37.7363531709501 | -122.386007687413 | (37.7363531709501, -122.386007687413) | ||
| 16548 | 16548 | 22320 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5130 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014589.6697 | 2094475.5245 | 37.731851070935704 | -122.391889691503 | (37.7318510709357, -122.391889691503) | |||
| 16596 | 16596 | 24297 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016221.017419999 | 2096090.1073 | 37.736374822132504 | -122.386362260423 | (37.7363748221325, -122.386362260423) | |||
| 16627 | 16627 | 24444 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4512X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1995 12:00:00 AM | 6 | 3x3 | 6015145.0249 | 2096325.3607 | 37.7369611611957 | -122.390098878017 | (37.7369611611957, -122.390098878017) | ||
| 16647 | 16647 | 22313 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5114 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3x3 | 6014616.1025 | 2094561.5804 | 37.7320888303862 | -122.391804322113 | (37.7320888303862, -122.391804322113) | ||
| 16800 | 16800 | 91697 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1699 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007471.37046 | 2108630.96251 | 37.770320947775396 | -122.41750205429399 | (37.7703209477754, -122.417502054294) | ||
| 16867 | 16867 | 84834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010439.60599 | 2111868.75172 | 37.7793777314294 | -122.40746318667 | (37.7793777314294, -122.40746318667) | ||
| 17414 | 17414 | 24350 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 69 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 3 | 3X3 | 6006243.86106 | 2108474.23182 | 37.769821458035295 | -122.42173687996001 | (37.7698214580353, -122.42173687996) | ||
| 17529 | 17529 | 27492 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3X3 | 6006409.07404 | 2101649.59564 | 37.7510919153811 | -122.420680862742 | (37.7510919153811, -122.420680862742) | ||
| 17616 | 17616 | 25607 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1225 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2000 12:00:00 AM | 3 | 3X3 | 6008935.12695 | 2097525.18951 | 37.7399092531173 | -122.411654094874 | (37.7399092531173, -122.411654094874) | ||
| 17980 | 17980 | 51193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 18421 | 18421 | 32094 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4056 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 16 | 4x4 | Permit Number 35466 | 6002634.735280001 | 2104754.49716 | 37.759403787880004 | -122.43395481658399 | (37.75940378788, -122.433954816584) |
| 18671 | 18671 | 25608 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1201 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6008878.530040001 | 2097513.7909999997 | 37.7398747802954 | -122.41184897886801 | (37.7398747802954, -122.411848978868) |
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");