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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 15264 | 15264 | 105277 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.2864900003 | 37.781171886114706 | -122.38996007562 | (37.7811718861147, -122.38996007562) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 15430 | 15430 | 98183 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009361.09189 | 2110925.30032 | 37.7767268106175 | -122.411127574195 | (37.7767268106175, -122.411127574195) | |||
| 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) | |
| 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) | |||
| 15862 | 15862 | 114993 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 96X Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6013204.76311 | 2114263.56563 | 37.78610772254971 | -122.398065333368 | (37.7861077225497, -122.398065333368) | |||
| 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) | ||
| 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) | |||
| 16153 | 16153 | 98184 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777050 | 6009341.871809999 | 2110905.80719 | 37.7766722091935 | -122.41119268511001 | (37.7766722091935, -122.41119268511) | |
| 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) | ||
| 16459 | 16459 | 102415 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 286 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010900.79062 | 2111559.68279 | 37.7785549030328 | -122.405845970014 | (37.7785549030328, -122.405845970014) | |||
| 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) | ||
| 16823 | 16823 | 22249 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6015186.4487 | 2096240.2877 | 37.7367298654987 | -122.38994971533998 | (37.7367298654987, -122.38994971534) | ||
| 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) | ||
| 16929 | 16929 | 16335 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996588.55754 | 2094717.49275 | 37.7314996764704 | -122.454140408353 | (37.7314996764704, -122.454140408353) | ||
| 17060 | 17060 | 16342 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5996198.48565 | 2094691.8474400002 | 37.731406885306704 | -122.455487100866 | (37.7314068853067, -122.455487100866) | |||
| 17099 | 17099 | 16338 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996505.10477 | 2094713.35848 | 37.7314835390346 | -122.454428620411 | (37.7314835390346, -122.454428620411) | ||
| 17126 | 17126 | 16113 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999657.47743 | 2094677.0013700002 | 37.7315639977654 | -122.443527690574 | (37.7315639977654, -122.443527690574) | ||
| 17206 | 17206 | 16009 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001288.3370900005 | 2094653.38984 | 37.731592040430705 | -122.43788781177099 | (37.7315920404307, -122.437887811771) | ||
| 17219 | 17219 | 15306 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2012 12:00:00 AM | 12 | 4X4 | 6006908.0519 | 2109118.2179 | 37.7716271230049 | -122.41948515010701 | (37.7716271230049, -122.419485150107) | ||
| 17393 | 17393 | 16115 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999569.73094 | 2094680.4197799999 | 37.7315683792686 | -122.44383129178101 | (37.7315683792686, -122.443831291781) | ||
| 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) | ||
| 17507 | 17507 | 16015 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000956.04768 | 2094656.76286 | 37.731582400588294 | -122.43903684047899 | (37.7315824005883, -122.439036840479) | |||
| 17516 | 17516 | 16016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000925.306059999 | 2094658.03828 | 37.7315841533775 | -122.43914321141001 | (37.7315841533775, -122.43914321141) | |||
| 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) | ||
| 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) | |||
| 18069 | 18069 | 15305 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006919.2009 | 2109139.6581 | 37.7716866206556 | -122.41944810628799 | (37.7716866206556, -122.419448106288) | |||
| 18176 | 18176 | 16013 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6001154.39221 | 2094654.56847 | 37.731587658935396 | -122.43835096892201 | (37.7315876589354, -122.438350968922) | |||
| 18181 | 18181 | 7048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001113.3036400005 | 2110008.37363 | 37.7737431739315 | -122.43959330500601 | (37.7737431739315, -122.439593305006) | ||||
| 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) | |||
| 18343 | 18343 | 16048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 4 | 6000504.30929 | 2094664.8510599998 | 37.7315788950381 | -122.440599164328 | (37.7315788950381, -122.440599164328) | ||
| 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) |
| 18570 | 18570 | 119857 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401 Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 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) | ||
| 18929 | 18929 | 16187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999317.5789 | 2094684.3827099998 | 37.731564874619 | -122.44470331222901 | (37.731564874619, -122.444703312229) | |||
| 19005 | 19005 | 16334 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996621.72685 | 2094716.0654099998 | 37.731497659285104 | -122.45402563328001 | (37.7314976592851, -122.45402563328) | ||
| 19058 | 19058 | 93046 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 155 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5987682.5 | 2114946.6 | 37.7865285787391 | -122.48641460847601 | (37.7865285787391, -122.486414608476) | |||
| 19198 | 19198 | 10243 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 80X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 8 | 3X3 | 6005750.7633 | 2109671.0107 | 37.7730797066295 | -122.423527591987 | (37.7730797066295, -122.423527591987) | ||
| 19414 | 19414 | 16111 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999725.13349 | 2094678.46865 | 37.7315718848268 | -122.443293896493 | (37.7315718848268, -122.443293896493) | |||
| 19527 | 19527 | 24348 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 85 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6006216.94974 | 2108473.11084 | 37.7698168624935 | -122.421829886054 | (37.7698168624935, -122.421829886054) | |||
| 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) | |||
| 19693 | 19693 | 45729 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 19708 | 19708 | 16012 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001201.17189 | 2094653.91848 | 37.7315885348835 | -122.43818919619301 | (37.7315885348835, -122.438189196193) | ||
| 19772 | 19772 | 23092 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1370 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3X3 | 6006411.6799099995 | 2101600.51519 | 37.7509572985639 | -122.420668367552 | (37.7509572985639, -122.420668367552) | ||
| 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) | ||
| 19907 | 19907 | 16336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996559.751619999 | 2094715.89038 | 37.7314936249086 | -122.454239879686 | (37.7314936249086, -122.454239879686) | ||
| 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) | ||
| 20214 | 20214 | 16047 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6000544.66834 | 2094663.6950599998 | 37.731578019092396 | -122.440459552683 | (37.7315780190924, -122.440459552683) | ||||
| 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) | ||
| 20271 | 20271 | 23093 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1370 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3X3 | 6006411.8269 | 2101585.66917 | 37.7509165430738 | -122.420666805454 | (37.7509165430738, -122.420666805454) | ||
| 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) | ||
| 20354 | 20354 | 27346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000818.28486 | 2094659.29899 | 37.731581524667504 | -122.43951329411301 | (37.7315815246675, -122.439513294113) | |||
| 20419 | 20419 | 16017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000892.30856 | 2094658.72213 | 37.7315841533843 | -122.43925733896002 | (37.7315841533843, -122.43925733896) | |||
| 20443 | 20443 | 16112 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999693.39114 | 2094677.85118 | 37.7315683792706 | -122.443403591302 | (37.7315683792706, -122.443403591302) | |||
| 20489 | 20489 | 96596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988207.53014 | 2111924.69302 | 37.7782618665825 | -122.48437643702499 | (37.7782618665825, -122.484376437025) | ||
| 20512 | 20512 | 16106 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999928.25024 | 2094674.5701 | 37.731572760761104 | -122.44259140457599 | (37.7315727607611, -122.442591404576) |
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");