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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62 | 62 | 239043 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006946.59098 | 2109912.5632700003 | 37.773810376676295 | -122.41940820332898 | (37.7738103766763, -122.419408203329) | |||
| 257 | 257 | 251260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1163 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007684.87734 | 2102881.8281400003 | 37.754547168222295 | -122.41635626045701 | (37.7545471682223, -122.416356260457) | ||||
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 998 | 998 | 106624 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.78263288517989 | -122.455515759177 | (37.7826328851799, -122.455515759177) | ||
| 1359 | 1359 | 196907 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 351 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011780.0 | 2112595.0 | 37.7814467742932 | -122.40287726647301 | (37.7814467742932, -122.402877266473) | |||
| 1427 | 1427 | 196746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1201x 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012720.73761 | 2107120.44123 | 37.7664673626982 | -122.399238333493 | (37.7664673626982, -122.399238333493) | |||
| 1541 | 1541 | 196583 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010636.210390001 | 2110621.8756 | 37.7759651028325 | -122.406695151275 | (37.7759651028325, -122.406695151275) | |||
| 1554 | 1554 | 196582 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010641.65206 | 2110616.23142 | 37.7759499096844 | -122.40667592917801 | (37.7759499096844, -122.406675929178) | |||
| 2092 | 2092 | 196948 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3536 Jennings St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6013049.3063900005 | 2089480.54762 | 37.718050242412296 | -122.39686501810199 | (37.7180502424123, -122.396865018102) | |||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 3254 | 3254 | 244746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 98 12th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6007069.86029 | 2109755.10428 | 37.7733849739584 | -122.418970623803 | (37.7733849739584, -122.418970623803) | |||
| 3710 | 3710 | 240036 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4121 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002205.0 | 2105251.0 | 37.7607426677704 | -122.435476567852 | (37.7607426677704, -122.435476567852) | |||
| 3897 | 3897 | 253589 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | ||||
| 3905 | 3905 | 196577 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | |||
| 3984 | 3984 | 102394 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30X Harriet St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010499.119030001 | 2111685.94424 | 37.778879115810795 | -122.407244414896 | (37.7788791158108, -122.407244414896) | |||
| 3998 | 3998 | 159324 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 516 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:39:00 AM | 3 | Width 0ft | 5998061.98233 | 2087178.88925 | 37.710884802276205 | -122.44850380581998 | (37.7108848022762, -122.44850380582) | ||
| 4015 | 4015 | 159294 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 118 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:12:00 PM | 3 | Width 0ft | 5998151.37307 | 2087303.3135799998 | 37.7112315538724 | -122.44820380548799 | (37.7112315538724, -122.448203805488) | ||
| 4025 | 4025 | 159222 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 384 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:28:00 AM | 3 | Width 0ft | 5998624.92984 | 2087716.64467 | 37.712393528324206 | -122.446596800611 | (37.7123935283242, -122.446596800611) | ||
| 4042 | 4042 | 179821 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 364 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:07:00 AM | 3 | Width 2ft | 5998698.94465 | 2087786.79601 | 37.712590375508796 | -122.446346027354 | (37.7125903755088, -122.446346027354) | ||
| 4052 | 4052 | 102393 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30X Harriet St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010484.4318 | 2111700.90158 | 37.7789193631694 | -122.407296278794 | (37.7789193631694, -122.407296278794) | |||
| 4087 | 4087 | 159329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 556 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:09:00 AM | 3 | Width 0ft | 5997921.94288 | 2087046.44589 | 37.7105131349458 | -122.448978278232 | (37.7105131349458, -122.448978278232) | ||
| 4104 | 4104 | 159219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 366 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:32:00 AM | 3 | Width 0ft | 5998673.37335 | 2087760.7240000002 | 37.7125173271842 | -122.446432534932 | (37.7125173271842, -122.446432534932) | ||
| 4119 | 4119 | 159216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 326 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:09:00 AM | 3 | Width 0ft | 5998830.44796 | 2087909.1779599998 | 37.712933918350394 | -122.445900308946 | (37.7129339183504, -122.445900308946) | ||
| 4129 | 4129 | 216706 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 231 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:40:00 AM | 3 | Width 3ft | 5994712.86869 | 2090137.86358 | 37.718817384787606 | -122.460293291921 | (37.7188173847876, -122.460293291921) | ||
| 4175 | 4175 | 244050 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997945.2406 | 2109187.6851 | 37.771308954489 | -122.45049290616699 | (37.771308954489, -122.450492906167) | |||
| 4230 | 4230 | 244048 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997950.1933 | 2109141.0477 | 37.771181183618395 | -122.45047241196801 | (37.7711811836184, -122.450472411968) | |||
| 4233 | 4233 | 244049 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997947.3042 | 2109165.8109 | 37.7712490116574 | -122.450484190924 | (37.7712490116574, -122.450484190924) | |||
| 4717 | 4717 | 240016 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 6 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x6 | 6003449.63845 | 2105676.77669 | 37.7619823582336 | -122.431202314632 | (37.7619823582336, -122.431202314632) | |||
| 5177 | 5177 | 213769 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001465.0 | 2095917.0 | 37.735071666753 | -122.437367503603 | (37.735071666753, -122.437367503603) | |||
| 5608 | 5608 | 106622 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.2478 | 2113322.09 | 37.78258266885771 | -122.455516779687 | (37.7825826688577, -122.455516779687) | ||
| 8313 | 8313 | 110973 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2231 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002796.68152 | 2115999.3322 | 37.7902885034734 | -122.434198615596 | (37.7902885034734, -122.434198615596) | |||
| 13402 | 13402 | 98185 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009313.61515 | 2110882.15559 | 37.7766056827446 | -122.41128876238001 | (37.7766056827446, -122.41128876238) | |||
| 13850 | 13850 | 98187 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777050 | 6009249.68117 | 2110819.91866 | 37.7764312088743 | -122.41150553135598 | (37.7764312088743, -122.411505531356) | |
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 14105 | 14105 | 102389 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 90X Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.24129 | 2111421.87021 | 37.7781680812419 | -122.406357067338 | (37.7781680812419, -122.406357067338) | |||
| 14719 | 14719 | 98186 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009297.66811 | 2110865.56699 | 37.7765592399587 | -122.411342755875 | (37.7765592399587, -122.411342755875) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 23595 | 23595 | 136131 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Hemlock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006507.20289 | 2114786.55408 | 37.78716841265071 | -122.42127429839701 | (37.7871684126507, -122.421274298397) | |||
| 23728 | 23728 | 240105 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 8 Landers St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004445.22444 | 2107657.1066799997 | 37.767476238364395 | -122.427900086823 | (37.7674762383644, -122.427900086823) | |||
| 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) | |||
| 23900 | 23900 | 136080 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2451 Steiner St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002277.07488 | 2116237.64468 | 37.7909133434315 | -122.43601347444799 | (37.7909133434315, -122.436013474448) | |||
| 23964 | 23964 | 239744 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 568 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001504.60892 | 2100890.93751 | 37.7487311832969 | -122.437586652201 | (37.7487311832969, -122.437586652201) | |||
| 24120 | 24120 | 179207 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006573.63704 | 2087691.58982 | 37.7127755684169 | -122.41912182232402 | (37.7127755684169, -122.419121822324) | |||
| 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) | |||
| 24327 | 24327 | 136155 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007553.7315 | 2120957.34522 | 37.8041708145069 | -122.418091165079 | (37.8041708145069, -122.418091165079) | |||
| 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) | |||
| 24506 | 24506 | 213803 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 216 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991962.814730001 | 2089977.4457200002 | 37.7182183418945 | -122.469787374494 | (37.7182183418945, -122.469787374494) | |||
| 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) | |||
| 24820 | 24820 | 244313 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 355 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005485.8375 | 2110599.8191 | 37.77561503254971 | -122.424510084491 | (37.7756150325497, -122.424510084491) | |||
| 24824 | 24824 | 136161 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011844.59181 | 2120106.54793 | 37.8020753041917 | -122.40318235259399 | (37.8020753041917, -122.403182352594) | |||
| 24877 | 24877 | 239855 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 130 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007274.472630001 | 2099692.72245 | 37.745767519658706 | -122.41754954119301 | (37.7457675196587, -122.417549541193) | |||
| 24905 | 24905 | 196689 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6015659.73754 | 2114184.09825 | 37.7860259507775 | -122.38956615096701 | (37.7860259507775, -122.389566150967) | |||
| 24909 | 24909 | 196684 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015730.46543 | 2114303.5098599996 | 37.7863577493517 | -122.389329791131 | (37.7863577493517, -122.389329791131) | |||
| 24924 | 24924 | 196625 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 147 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012482.23546 | 2114419.12647 | 37.7864945874895 | -122.400576033651 | (37.7864945874895, -122.400576033651) | |||
| 24996 | 24996 | 196826 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014562.70735 | 2108760.4377599997 | 37.7710729141165 | -122.392981999126 | (37.7710729141165, -122.392981999126) | |||
| 25140 | 25140 | 239844 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Kingston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006073.52024 | 2098158.83629 | 37.741488165849105 | -122.42159334545099 | (37.7414881658491, -122.421593345451) | |||
| 25203 | 25203 | 196859 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 434 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011421.85676 | 2112297.76071 | 37.7806106201269 | -122.404095350623 | (37.7806106201269, -122.404095350623) | |||
| 25349 | 25349 | 196709 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015487.2146 | 2112506.03774 | 37.7814088089166 | -122.390045771117 | (37.7814088089166, -122.390045771117) | |||
| 25514 | 25514 | 239832 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 76 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009261.2334 | 2097625.2894200003 | 37.740202393439205 | -122.41053361693301 | (37.7402023934392, -122.410533616933) | |||
| 25714 | 25714 | 196574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 282 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6011149.22911 | 2111419.33677 | 37.7781834362492 | -122.404976637663 | (37.7781834362492, -122.404976637663) | |||
| 25835 | 25835 | 238959 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1111 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009480.56073 | 2102670.61993 | 37.7540680517192 | -122.41013137718299 | (37.7540680517192, -122.410131377183) | |||
| 26059 | 26059 | 239748 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 25 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000981.99156 | 2101546.28179 | 37.7505008737212 | -122.439440825843 | (37.7505008737212, -122.439440825843) | |||
| 26072 | 26072 | 136103 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2670 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001647.44385 | 2117615.48557 | 37.794660747350605 | -122.43829071794701 | (37.7946607473506, -122.438290717947) | |||
| 26179 | 26179 | 179193 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005644.83636 | 2087196.5165400002 | 37.7113638531203 | -122.422296907583 | (37.7113638531203, -122.422296907583) | |||
| 26217 | 26217 | 200688 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4705 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015005.5461 | 2095633.7106 | 37.7350542941254 | -122.39053280741999 | (37.7350542941254, -122.39053280742) | |||
| 26344 | 26344 | 196782 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014472.23828 | 2109430.12451 | 37.7729066992149 | -122.393341808879 | (37.7729066992149, -122.393341808879) | |||
| 26475 | 26475 | 196593 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 966 Natoma St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007961.50634 | 2109867.3377900003 | 37.7737433088451 | -122.41589423462798 | (37.7737433088451, -122.415894234628) | |||
| 26559 | 26559 | 245949 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 751 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997948.2269 | 2107812.3026 | 37.767532676646205 | -122.450383412512 | (37.7675326766462, -122.450383412512) | |||
| 26612 | 26612 | 239801 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 455 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003719.083459999 | 2096178.0797599999 | 37.735916419701205 | -122.42959294547701 | (37.7359164197012, -122.429592945477) | |||
| 26779 | 26779 | 196645 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 46 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013699.06436 | 2114734.2176200002 | 37.787427542398504 | -122.396388171474 | (37.7874275423985, -122.396388171474) | |||
| 26821 | 26821 | 196616 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 761 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6011860.50981 | 2114097.56816 | 37.785576970551 | -122.402704440271 | (37.785576970551, -122.402704440271) | |||
| 26831 | 26831 | 248160 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Rutledge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010158.71072 | 2099550.9487099997 | 37.7455401098893 | -122.407566222029 | (37.7455401098893, -122.407566222029) | |||
| 26852 | 26852 | 196627 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 147 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012623.58096 | 2114312.81429 | 37.7862105609171 | -122.40007954136401 | (37.7862105609171, -122.400079541364) | |||
| 26857 | 26857 | 239819 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007679.66756 | 2096504.8408400002 | 37.7370370945787 | -122.41592272607001 | (37.7370370945787, -122.41592272607) | |||
| 26875 | 26875 | 179199 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | |||
| 26907 | 26907 | 179220 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006068.28025 | 2087832.3093700001 | 37.7131334823856 | -122.420878485149 | (37.7131334823856, -122.420878485149) | |||
| 27052 | 27052 | 136144 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 240 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006227.72635 | 2110929.7096 | 37.7765627005485 | -122.421967145061 | (37.7765627005485, -122.421967145061) | |||
| 27057 | 27057 | 238975 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 181 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6006722.09906 | 2102742.62319 | 37.7541107560263 | -122.419675932416 | (37.7541107560263, -122.419675932416) | |||
| 27112 | 27112 | 196886 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 433 Clementina St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011428.028580001 | 2112266.0356400004 | 37.780523855317 | -122.404071765908 | (37.780523855317, -122.404071765908) | |||
| 27155 | 27155 | 239752 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 845 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001933.47511 | 2101528.47832 | 37.7505060933955 | -122.43614925500201 | (37.7505060933955, -122.436149255002) | |||
| 27227 | 27227 | 196669 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013576.19768 | 2114348.87912 | 37.786362654248 | -122.396786242904 | (37.786362654248, -122.396786242904) | |||
| 27232 | 27232 | 240094 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Beaver St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002810.74137 | 2106823.9514 | 37.765095995496395 | -122.43349399227101 | (37.7650959954964, -122.433493992271) | |||
| 27260 | 27260 | 239993 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3945 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004204.66413 | 2101286.73756 | 37.749971103789896 | -122.428278082666 | (37.7499711037899, -122.428278082666) | |||
| 27372 | 27372 | 196638 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013210.02974 | 2115178.55923 | 37.7886203752705 | -122.398111327376 | (37.7886203752705, -122.398111327376) | |||
| 27450 | 27450 | 196678 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6015773.95432 | 2114161.0463099997 | 37.7859689877116 | -122.389169378158 | (37.7859689877116, -122.389169378158) | |||
| 27467 | 27467 | 238993 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006229.76943 | 2101018.50023 | 37.7493489644829 | -122.421256107802 | (37.7493489644829, -122.421256107802) |
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");