Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14060 | 14060 | 22317 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 5122 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/1992 12:00:00 AM | 3 | 3x3 | 6014608.749 | 2094535.9425 | 37.7320180256942 | -122.39182795294201 | (37.7320180256942, -122.391827952942) | ||
| 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) | |||
| 14558 | 14558 | 22291 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/13/1999 12:00:00 AM | 3 | 3x3 | 6014819.739 | 2095230.8817 | 37.733937898392206 | -122.391147066285 | (37.7339378983922, -122.391147066285) | ||
| 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) | |||
| 14658 | 14658 | 10994 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2013 12:00:00 AM | 3 | 3X3 | 6016116.07134 | 2097158.9292099997 | 37.7393037809554 | -122.38679962052099 | (37.7393037809554, -122.386799620521) | ||
| 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) | |||
| 14965 | 14965 | 95845 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 148 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010292.7909 | 2112199.1337200003 | 37.780276664085704 | -122.40799438924999 | (37.7802766640857, -122.40799438925) | |||
| 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) | ||
| 15118 | 15118 | 22247 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015208.4261 | 2096311.2431 | 37.7369259133775 | -122.3898786841 | (37.7369259133775, -122.3898786841) | |||
| 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) | |||
| 15232 | 15232 | 95293 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4618 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015049.0735 | 2096005.3469 | 37.7360771463621 | -122.390408274564 | (37.7360771463621, -122.390408274564) | |||
| 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) | ||
| 15386 | 15386 | 22255 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4614 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1996 12:00:00 AM | 6 | 3x3 | 6015052.7639 | 2096021.1630000002 | 37.7361207788628 | -122.390396619988 | (37.7361207788628, -122.390396619988) | ||
| 15407 | 15407 | 101368 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 555 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 1 | 3x5 | Permit Number 769424 | 6009870.786169999 | 2111925.3371200003 | 37.77950124702579 | -122.40943497635901 | (37.7795012470258, -122.409434976359) | |
| 15412 | 15412 | 117198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 78 Ringold St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x2.5 | 6009460.131469999 | 2109802.88553 | 37.773650476322295 | -122.410705680637 | (37.7736504763223, -122.410705680637) | |||
| 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) | |||
| 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) | |||
| 15851 | 15851 | 95291 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4500 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015158.7323 | 2096375.4452 | 37.73709944325871 | -122.390054982777 | (37.7370994432587, -122.390054982777) | |||
| 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) | ||
| 15991 | 15991 | 22288 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1998 12:00:00 AM | 3 | 3X3 | 6014865.0787 | 2095383.7713 | 37.7343602181244 | -122.391000994081 | (37.7343602181244, -122.391000994081) | ||
| 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) | |||
| 16287 | 16287 | 22251 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4522 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1995 12:00:00 AM | 6 | 3x3 | 6015135.007999999 | 2096296.8916 | 37.7368824352823 | -122.390131522919 | (37.7368824352823, -122.390131522919) | ||
| 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) | ||
| 16373 | 16373 | 114992 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 96X Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6013259.23301 | 2114318.42588 | 37.786261389694296 | -122.397880730433 | (37.7862613896943, -122.397880730433) | |||
| 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) | ||
| 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) | ||
| 17448 | 17448 | 5159 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 280 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 3 | 3x3 | 6001840.8605 | 2109274.7601 | 37.7717702359874 | -122.43702404315799 | (37.7717702359874, -122.437024043158) | ||
| 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) | ||
| 17572 | 17572 | 5174 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/28/2006 12:00:00 AM | 3 | 3x4 | 6001785.2321 | 2109677.0482 | 37.7728716568906 | -122.437245274575 | (37.7728716568906, -122.437245274575) | |
| 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) | ||
| 18219 | 18219 | 5158 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 275 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001773.6501 | 2109268.6052 | 37.771749515715605 | -122.437256087151 | (37.7717495157156, -122.437256087151) | |
| 18231 | 18231 | 25584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1100 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008703.17196 | 2097328.50441 | 37.739356184437796 | -122.412442202248 | (37.7393561844378, -122.412442202248) | |||
| 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) |
| 18577 | 18577 | 5154 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001780.9624 | 2109220.4101 | 37.771617599631604 | -122.43722734206499 | (37.7716175996316, -122.437227342065) | ||
| 18660 | 18660 | 2548 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 26 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001209.41963 | 2095931.6881 | 37.7350974637785 | -122.438252186489 | (37.7350974637785, -122.438252186489) | ||
| 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) | ||
| 18764 | 18764 | 16103 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/2012 12:00:00 AM | 2 | 5 | 6000043.907980001 | 2094672.48858 | 37.7315736376005 | -122.44219140500799 | (37.7315736376005, -122.442191405008) | ||
| 18798 | 18798 | 24364 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 94X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | 3 | 3X3 | 6006127.193940001 | 2108531.26259 | 37.769971471229994 | -122.42214448149099 | (37.76997147123, -122.422144481491) | ||
| 19610 | 19610 | 16184 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999406.634869999 | 2094682.7033 | 37.7315653449635 | -122.444395308802 | (37.7315653449635, -122.444395308802) | |||
| 19681 | 19681 | 100150 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4007 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002942.0 | 2105314.0 | 37.7609574805046 | -122.432932117926 | (37.7609574805046, -122.432932117926) | |||
| 19868 | 19868 | 25582 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1050 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 6 | 3X3 | 6008562.72198 | 2097229.54928 | 37.7390765924125 | -122.412920823236 | (37.7390765924125, -122.412920823236) | ||
| 20041 | 20041 | 16019 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2003 12:00:00 AM | 3 | 3x3 | 6001362.879269999 | 2094609.69043 | 37.7314762904984 | -122.43762697692301 | (37.7314762904984, -122.437626976923) | ||
| 20046 | 20046 | 5155 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 265 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001777.3063 | 2109242.3472 | 37.7716776256193 | -122.43724155970399 | (37.7716776256193, -122.437241559704) | |
| 20084 | 20084 | 32102 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 184 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | 16 | 4x4 | Permit Number 35474 | 6002676.86971 | 2104831.86113 | 37.759618601743796 | -122.43381462484601 | (37.7596186017438, -122.433814624846) | |
| 20107 | 20107 | 4293 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4339 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001695.46709 | 2100282.2377 | 37.747070687663204 | -122.436883097284 | (37.7470706876632, -122.436883097284) | |||
| 20187 | 20187 | 23091 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1370 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3X3 | 6006409.75471 | 2101616.74712 | 37.751001759225105 | -122.420676177262 | (37.7510017592251, -122.420676177262) | ||
| 20252 | 20252 | 2549 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 30 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001196.7389 | 2095889.2850400002 | 37.7349803135805 | -122.438292991438 | (37.7349803135805, -122.438292991438) | ||
| 20322 | 20322 | 2547 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 20 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2014 12:00:00 AM | 3 | 3x3 | 6001218.37586 | 2095964.9326099998 | 37.7351892548769 | -122.43822360245001 | (37.7351892548769, -122.43822360245) | ||
| 20726 | 20726 | 10242 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 80X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6005765.1512 | 2109670.3256 | 37.77307863760571 | -122.423477773641 | (37.7730786376057, -122.423477773641) | |||
| 20886 | 20886 | 25590 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1410X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2005 12:00:00 AM | 3 | 3X3 | 6009244.35736 | 2097447.67497 | 37.739713756686 | -122.410579428408 | (37.739713756686, -122.410579428408) | ||
| 20938 | 20938 | 5183 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 444 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1997 12:00:00 AM | 8 | 3X3 | 6001739.9704 | 2109977.4732 | 37.773693975909296 | -122.437423356744 | (37.7736939759093, -122.437423356744) | ||
| 21027 | 21027 | 25609 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1125 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6008736.292859999 | 2097412.56603 | 37.7395888579293 | -122.41233362442301 | (37.7395888579293, -122.412333624423) | ||
| 21064 | 21064 | 32070 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3684 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35444 | 6004359.136530001 | 2106017.2411 | 37.7629686905871 | -122.428080978261 | (37.7629686905871, -122.428080978261) |
| 21235 | 21235 | 63156 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.46937656879999 | (37.7605085633711, -122.4693765688) | ||
| 21472 | 21472 | 15304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.41940870477801 | (37.7717697147956, -122.419408704778) | |||
| 21633 | 21633 | 24512 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 149 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 6002253.37312 | 2107416.25284 | 37.766690671552794 | -122.43546416406001 | (37.7666906715528, -122.43546416406) | ||
| 21842 | 21842 | 25606 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1231 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6008981.38418 | 2097520.55197 | 37.7398991141649 | -122.41149382849599 | (37.7398991141649, -122.411493828496) | ||
| 22026 | 22026 | 25611 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1115X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1997 12:00:00 AM | 6 | 3X3 | 6008678.676080001 | 2097369.4322599997 | 37.739467188659205 | -122.412529790816 | (37.7394671886592, -122.412529790816) | ||
| 22107 | 22107 | 5173 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 341 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/2016 12:00:00 AM | 3 | 3x3 | 6001719.8045 | 2109652.5045 | 37.7728005464855 | -122.437469837978 | (37.7728005464855, -122.437469837978) | ||
| 22125 | 22125 | 16043 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 6000692.70251 | 2094661.9023 | 37.731581524671995 | -122.43994764238701 | (37.731581524672, -122.439947642387) | |||
| 22296 | 22296 | 104066 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 162 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010375.22772 | 2112112.8976 | 37.7800444950845 | -122.407703118631 | (37.7800444950845, -122.407703118631) | |||
| 22377 | 22377 | 9193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 6137 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5987931.1239 | 2112533.881 | 37.77991842635 | -122.485377329982 | (37.77991842635, -122.485377329982) | ||
| 22848 | 22848 | 196744 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 70 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6011668.77571 | 2109790.69 | 37.773740575795 | -122.40306474017099 | (37.773740575795, -122.403064740171) | |||
| 22999 | 22999 | 16007 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8 | 6001364.53052 | 2094649.25854 | 37.7315850293086 | -122.43762410089799 | (37.7315850293086, -122.437624100898) | |||
| 23007 | 23007 | 22285 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6014905.6735 | 2095512.4095 | 37.7347156849635 | -122.390869630779 | (37.7347156849635, -122.390869630779) | ||||
| 23134 | 23134 | 64386 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 3x3 | Permit Number 25228 | 6014088.71321 | 2113049.44965 | 37.782823232041395 | -122.39492201395299 | (37.7828232320414, -122.394922013953) |
| 23159 | 23159 | 16339 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996276.20802 | 2094704.1816900002 | 37.7314452117282 | -122.45521929265 | (37.7314452117282, -122.45521929265) | ||
| 23183 | 23183 | 5156 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 270 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/1990 12:00:00 AM | 2 | 6001844.2525 | 2109252.3731 | 37.7717089596497 | -122.43701070699899 | (37.7717089596497, -122.437010706999) | |||
| 23198 | 23198 | 16002 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3 | 6001503.91519 | 2094647.64932 | 37.7315885348642 | -122.43714210651699 | (37.7315885348642, -122.437142106517) | |||
| 23238 | 23238 | 7352 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2261 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 4 | 3X3 | 6002787.84589 | 2116061.09761 | 37.79045759399 | -122.434233603703 | (37.79045759399, -122.434233603703) | ||
| 23308 | 23308 | 14725 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 875 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 4x4 | 6001473.8635 | 2111422.6287 | 37.7776468775862 | -122.43844742023799 | (37.7776468775862, -122.438447420238) | ||
| 23321 | 23321 | 22241 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4430 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1995 12:00:00 AM | 4 | 3X3 | 6015210.0835 | 2096535.9422 | 37.7375429831649 | -122.38988864462 | (37.7375429831649, -122.38988864462) | ||
| 23404 | 23404 | 240048 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 43 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000857.65959 | 2104899.8955900003 | 37.7597020075671 | -122.440111226348 | (37.7597020075671, -122.440111226348) | |||
| 23524 | 23524 | 196682 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015696.3573900005 | 2114271.42038 | 37.786267747913996 | -122.389445555473 | (37.786267747914, -122.389445555473) | |||
| 23866 | 23866 | 213780 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 401 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999412.8800099995 | 2094425.91408 | 37.730860618202 | -122.444355271001 | (37.730860618202, -122.444355271001) | |||
| 24294 | 24294 | 240116 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999571.42153 | 2105391.81538 | 37.760979387506 | -122.444595026656 | (37.760979387506, -122.444595026656) | |||
| 24387 | 24387 | 196870 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 472 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010925.85315 | 2111832.37951 | 37.779305066206604 | -122.405778482215 | (37.7793050662066, -122.405778482215) | |||
| 24390 | 24390 | 183485 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1200 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988896.6651 | 2097669.2164 | 37.7391602759822 | -122.480948482471 | (37.7391602759822, -122.480948482471) | |||
| 24463 | 24463 | 238876 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1491 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007784.85752 | 2101047.0876700003 | 37.7495150081106 | -122.415880587419 | (37.7495150081106, -122.415880587419) | |||
| 24722 | 24722 | 238913 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1068 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007587.824440001 | 2103414.46405 | 37.7560042066578 | -122.41672962747299 | (37.7560042066578, -122.416729627473) | |||
| 24781 | 24781 | 239789 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 231 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004717.296 | 2096978.74622 | 37.738171339340205 | -122.42619871072901 | (37.7381713393402, -122.426198710729) |
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");