Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14 | 14 | 196590 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 772992 | 6007565.6944699995 | 2109618.27361 | 37.773037177355796 | -122.41724576098301 | (37.7730371773558, -122.417245760983) | ||
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 30 | 30 | 196592 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.41735848920901 | (37.7731013709756, -122.417358489209) | ||
| 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) | ||||
| 324 | 324 | 244302 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005598.2085 | 2110574.7953 | 37.775552668496104 | -122.424119585265 | (37.7755526684961, -122.424119585265) | |||
| 331 | 331 | 244290 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 201 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005571.2897 | 2110005.1565 | 37.7739870584615 | -122.424172183065 | (37.7739870584615, -122.424172183065) | |||
| 332 | 332 | 244303 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | 6005595.8477 | 2110592.7369 | 37.775601798483 | -122.42412902808998 | (37.775601798483, -122.42412902809) | |||
| 335 | 335 | 244346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005627.7176 | 2110356.4274 | 37.77495474924589 | -122.42400197393101 | (37.7749547492459, -122.424001973931) | |||
| 336 | 336 | 244304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005592.0705 | 2110609.2621 | 37.775646959405705 | -122.42414326985501 | (37.7756469594057, -122.424143269855) | |||
| 338 | 338 | 244347 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.3569 | 2110371.5361 | 37.774996100795995 | -122.424011214757 | (37.774996100796, -122.424011214757) | |||
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 980 | 980 | 22300 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 5000 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6014732.2229 | 2094948.8267 | 37.7331585757016 | -122.391429927203 | (37.7331585757016, -122.391429927203) | |||
| 985 | 985 | 97601 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 855 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001476.9066 | 2111398.2834 | 37.7775802046297 | -122.43843514847099 | (37.7775802046297, -122.438435148471) | ||
| 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) | ||
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 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) | |||
| 1522 | 1522 | 251579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | ||||
| 1534 | 1534 | 196952 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | |||
| 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) | |||
| 1544 | 1544 | 196581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.77593015789721 | -122.40664901875 | (37.7759301578972, -122.40664901875) | |||
| 1552 | 1552 | 196579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6010663.40725 | 2110593.10143 | 37.775887617266605 | -122.406599041617 | (37.7758876172666, -122.406599041617) | |||
| 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) | |||
| 1558 | 1558 | 196580 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6010653.5672 | 2110601.04867 | 37.7759088880156 | -122.406633641224 | (37.7759088880156, -122.406633641224) | |||
| 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) | |||
| 2146 | 2146 | 87638 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2999 | 2999 | 141643 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 705 DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001547.0457 | 2110892.7785 | 37.7761962047839 | -122.43815629312599 | (37.7761962047839, -122.438156293126) | |||
| 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 | ||||||||
| 3014 | 3014 | 141613 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 705 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001544.5033 | 2110907.0163 | 37.7762351536088 | -122.43816610813299 | (37.7762351536088, -122.438166108133) | |||
| 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) | |||
| 3626 | 3626 | 5935 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1357 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003980.6032 | 2112841.5446 | 37.7816851365454 | -122.429876994211 | (37.7816851365454, -122.429876994211) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
| 4425 | 4425 | 97577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001652.1221 | 2110620.3263 | 37.775454094869296 | -122.43777328811301 | (37.7754540948693, -122.437773288113) | ||
| 4599 | 4599 | 100201 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 255 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51875 | 6008346.927130001 | 2112747.04212 | 37.7816719523255 | -122.414764839028 | (37.7816719523255, -122.414764839028) | ||
| 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) | |||
| 4739 | 4739 | 3036 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2607 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X2 | 6001811.8813 | 2115314.7838 | 37.7883529667295 | -122.437556903926 | (37.7883529667295, -122.437556903926) | |||
| 5125 | 5125 | 97583 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001590.7259 | 2111040.5 | 37.776604295001 | -122.438015775508 | (37.776604295001, -122.438015775508) | ||
| 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) | |||
| 5188 | 5188 | 158290 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 901 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 0ft | 6001465.0 | 2095917.0 | 37.735071666753 | -122.437367503603 | (37.735071666753, -122.437367503603) | |||
| 5389 | 5389 | 27381 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006997.70161 | 2121072.6946 | 37.8044562233376 | -122.42002354287901 | (37.8044562233376, -122.420023542879) | |||
| 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) | ||
| 5728 | 5728 | 97579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001646.5608 | 2110651.222 | 37.7755386104847 | -122.437794739235 | (37.7755386104847, -122.437794739235) | ||
| 5871 | 5871 | 97602 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 833 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3xe | 6001492.376 | 2111306.2278 | 37.777328323069796 | -122.438375037891 | (37.7773283230698, -122.438375037891) | ||
| 5874 | 5874 | 97590 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 559 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.3648 | 2110410.2466 | 37.774875178544995 | -122.437885389718 | (37.774875178545, -122.437885389718) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
| 6007 | 6007 | 28723 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003233.5773 | 2114519.7036 | 37.7862506062504 | -122.43258125527099 | (37.7862506062504, -122.432581255271) | |||
| 6089 | 6089 | 11017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | |||
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 6693 | 6693 | 7357 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002807.95732 | 2116239.44488 | 37.7909484313614 | -122.43417677466499 | (37.7909484313614, -122.434176774665) | |||
| 7406 | 7406 | 97595 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x4 | 6001524.4178 | 2111055.242 | 37.7766410017417 | -122.438246210395 | (37.7766410017417, -122.438246210395) | ||
| 7792 | 7792 | 97581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001597.3606 | 2110988.4698 | 37.776461810461704 | -122.43798909643101 | (37.7764618104617, -122.437989096431) | ||
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 8303 | 8303 | 97591 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001649.1323 | 2110166.4258 | 37.7742076278049 | -122.43775111477899 | (37.7742076278049, -122.437751114779) | ||
| 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) | |||
| 8394 | 8394 | 97584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 818 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001564.5243 | 2111243.3358 | 37.777159740959895 | -122.43812094768101 | (37.7771597409599, -122.438120947681) | ||
| 8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
| 8461 | 8461 | 28724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003220.1851 | 2114518.78 | 37.7862473108086 | -122.432627522769 | (37.7862473108086, -122.432627522769) | |||
| 8586 | 8586 | 97596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 783 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001525.9433 | 2111041.0042 | 37.7766019950898 | -122.438239913038 | (37.7766019950898, -122.438239913038) | ||||
| 9356 | 9356 | 5932 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1355 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6004005.8425 | 2112845.6747 | 37.781697906038 | -122.429789972847 | (37.781697906038, -122.429789972847) | |||
| 9538 | 9538 | 24790 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600X Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | 5983417.22641 | 2112490.7888700003 | 37.7795361021078 | -122.500989471143 | (37.7795361021078, -122.500989471143) | |||
| 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) | |||
| 13434 | 13434 | 22229 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015364.7865 | 2096754.4159 | 37.73815144552721 | -122.38936901073099 | (37.7381514455272, -122.389369010731) | |||
| 13506 | 13506 | 22236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015297.7091 | 2096577.2751 | 37.737661333943 | -122.389588564769 | (37.737661333943, -122.389588564769) | |||
| 13553 | 13553 | 22248 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015177.6578 | 2096215.1707 | 37.7366604118004 | -122.389978355542 | (37.7366604118004, -122.389978355542) | |||
| 13619 | 13619 | 22307 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014686.8832 | 2094799.1002 | 37.7327449405845 | -122.391576215676 | (37.7327449405845, -122.391576215676) | ||||
| 13672 | 13672 | 22228 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015357.7009 | 2096730.7972 | 37.7380862005585 | -122.38939186050399 | (37.7380862005585, -122.389391860504) | |||
| 13695 | 13695 | 22311 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014675.8119 | 2094762.1958 | 37.7326429940585 | -122.391611912964 | (37.7326429940585, -122.391611912964) | |||
| 13871 | 13871 | 95055 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5100X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014636.9706 | 2094632.7306 | 37.7322853528356 | -122.39173714895 | (37.7322853528356, -122.39173714895) | |||
| 13950 | 13950 | 22303 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5012X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014706.917 | 2094874.4907 | 37.7329530595777 | -122.391512222074 | (37.7329530595777, -122.391512222074) | |||
| 14054 | 14054 | 95063 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4911 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014862.0973 | 2095159.3952 | 37.7337439615305 | -122.39099562481701 | (37.7337439615305, -122.390995624817) | |||
| 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) | |||
| 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) | |||
| 14392 | 14392 | 22293 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4910 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014812.3581 | 2095203.9942 | 37.733863661185495 | -122.39117070574301 | (37.7338636611855, -122.391170705743) | |||
| 14394 | 14394 | 24301 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 14 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016327.55349 | 2096048.14928 | 37.7362655104391 | -122.385990993297 | (37.7362655104391, -122.385990993297) | |||
| 14396 | 14396 | 92868 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014891.438999999 | 2095469.7059 | 37.7345976397448 | -122.39091586114999 | (37.7345976397448, -122.39091586115) | |||
| 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) | |||
| 14709 | 14709 | 22250 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015190.8442 | 2096262.8930000002 | 37.736792178811996 | -122.389936096639 | (37.736792178812, -122.389936096639) | |||
| 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) | |||
| 14827 | 14827 | 22296 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4920 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014793.9059 | 2095156.0185 | 37.7337309056506 | -122.391231148662 | (37.7337309056506, -122.391231148662) | |||
| 14874 | 14874 | 22298 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014820.3268 | 2095023.3662 | 37.73336813561429 | -122.391130534135 | (37.7333681356143, -122.391130534135) | |||
| 14958 | 14958 | 95062 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014835.7159 | 2095070.6328 | 37.7334987740836 | -122.39108063188101 | (37.7334987740836, -122.391080631881) | |||
| 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) | |||
| 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) |
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");