trees
713 rows where qSpecies_id = 102 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
| 1016 | 84387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012577.97369 | 2099023.613 | 37.7442272813575 | -122.399163722146 | (37.7442272813575, -122.399163722146) | 10 | 3 | 8 | 58 | 1 | |||
| 1593 | 259756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1523 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015921.70632 | 2096895.74231 | 37.7385703600528 | -122.387453298811 | (37.7385703600528, -122.387453298811) | 10 | 3 | 8 | 58 | 1 | |||
| 4597 | 190929 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | 10 | 3 | 8 | 28856 | 1 | |||
| 4875 | 261114 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 5755 | 261117 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 6349 | 78274 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1715 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013961.91267 | 2093099.05364 | 37.7280366912377 | -122.393963673903 | (37.7280366912377, -122.393963673903) | 10 | 3 | 8 | 58 | 1 | |||
| 7023 | 261112 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
| 8494 | 261111 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 9100 | 84393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6012494.05335 | 2099085.01558 | 37.7443912025977 | -122.399458212338 | (37.7443912025977, -122.399458212338) | 10 | 3 | 8 | 58 | 1 | |||
| 11533 | 259758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1547 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015798.86195 | 2096987.35115 | 37.7388150947049 | -122.387884430038 | (37.7388150947049, -122.387884430038) | 10 | 3 | 8 | 58 | 1 | |||
| 13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
| 13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
| 13909 | 261115 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 14040 | 190944 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6014004.94796 | 2095137.53702 | 37.7336363433234 | -122.393957536921 | (37.7336363433234, -122.393957536921) | 10 | 3 | 8 | 58 | 1 | |||
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 15179 | 261113 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 16303 | 261116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 18209 | 78205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014348.06009 | 2094265.06475 | 37.7312597751042 | -122.392710275271 | (37.7312597751042, -122.392710275271) | 10 | 3 | 8 | 58 | 1 | |||
| 18431 | 51369 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889599 | (37.7324395857978, -122.39335889599) | 10 | 3 | 8 | 58 | 1 |
| 39104 | 190941 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.7334764187035 | -122.394092347086 | (37.7334764187035, -122.394092347086) | 10 | 3 | 8 | 58 | 1 | |||
| 43021 | 176078 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012689.21584 | 2087374.22772 | 37.7122466573345 | -122.397962026443 | (37.7122466573345, -122.397962026443) | 10 | 3 | 8 | 309 | 1 | |||
| 68909 | 176076 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 154 Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012994.7964 | 2086626.41439 | 37.7102103233239 | -122.396853446553 | (37.7102103233239, -122.396853446553) | 10 | 3 | 8 | 309 | 1 | |||
| 74485 | 190939 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1751 Newhall St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013890.69246 | 2094981.96022 | 37.733202810741 | -122.394341665249 | (37.733202810741, -122.394341665249) | 10 | 3 | 8 | 58 | 1 | |||
| 94557 | 66154 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1721 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | 7 | Permit Number 29225 | 6013940.43146 | 2095044.01963 | 37.7333759779235 | -122.394174046017 | (37.7333759779235, -122.394174046017) | 10 | 3 | 8 | 58 | 1 | |
| 104356 | 199804 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1315 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015572.2876 | 2090853.6469 | 37.7219606159851 | -122.388239865807 | (37.7219606159851, -122.388239865807) | 10 | 3 | 8 | 58 | 1 | |||
| 107999 | 190940 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1721 Newhall St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013954.61402 | 2095064.64022 | 37.7334333861362 | -122.394126455691 | (37.7334333861362, -122.394126455691) | 10 | 3 | 8 | 58 | 1 | |||
| 108831 | 190930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.7526299458258 | -122.390038764478 | (37.7526299458258, -122.390038764478) | 10 | 3 | 8 | 28856 | 1 | |||
| 114299 | 190932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | 10 | 3 | 8 | 28856 | 1 | |||
| 143673 | 199806 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1305 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015615.5318 | 2090822.5842 | 37.7218777199193 | -122.388088213537 | (37.7218777199193, -122.388088213537) | 10 | 3 | 8 | 58 | 1 | |||
| 156213 | 38599 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1334 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 1 | Permit Number 40550 | 6016508.9427 | 2093376.549 | 37.7289398652867 | -122.385177756249 | (37.7289398652867, -122.385177756249) | 10 | 3 | 8 | 58 | 1 | |
| 166719 | 190933 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | 10 | 3 | 8 | 28856 | 1 | |||
| 170665 | 190942 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6013977.60623 | 2095098.09187 | 37.7335265154282 | -122.39404930553 | (37.7335265154282, -122.39404930553) | 10 | 3 | 8 | 58 | 1 | |||
| 176902 | 51363 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014143.51923 | 2094573.18836 | 37.7320944574823 | -122.393438970749 | (37.7320944574823, -122.393438970749) | 10 | 3 | 8 | 58 | 1 |
| 180455 | 190931 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | 10 | 3 | 8 | 28856 | 1 | |||
| 186381 | 176077 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012696.95044 | 2087397.86987 | 37.7123120047722 | -122.397936950623 | (37.7123120047722, -122.397936950623) | 10 | 3 | 8 | 309 | 1 | |||
| 188607 | 190943 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6013990.64503 | 2095115.60513 | 37.7335753279298 | -122.3940054519 | (37.7335753279298, -122.3940054519) | 10 | 3 | 8 | 58 | 1 | |||
| 191082 | 84028 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 53 Waterville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50148 | 6011483.75557 | 2095836.15931 | 37.7354141717124 | -122.402723197432 | (37.7354141717124, -122.402723197432) | 10 | 3 | 8 | 58 | 1 | |
| 11345 | 140075 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 544 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005143.7718 | 2111312.9909 | 37.7775539050019 | -122.425744146907 | (37.7775539050019, -122.425744146907) | 7 | 9 | 11 | 28852 | 10 | |||
| 11641 | 223098 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004264.58531 | 2109293.13989 | 37.7719581680779 | -122.428641529305 | (37.7719581680779, -122.428641529305) | 7 | 9 | 11 | 28852 | 10 | |||
| 23956 | 255489 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 415 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781958 | 6004580.17678 | 2109974.62519 | 37.7738472162761 | -122.427598435585 | (37.7738472162761, -122.427598435585) | 7 | 9 | 11 | 28852 | 10 |
| 29934 | 49988 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300@ GOUGH Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005922.1673 | 2110886.7951 | 37.7764276301155 | -122.423021112586 | (37.7764276301155, -122.423021112586) | 7 | 9 | 11 | 28852 | 10 | ||
| 34628 | 223262 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003313.48049 | 2109165.67905 | 37.7715543194136 | -122.431922366729 | (37.7715543194136, -122.431922366729) | 15 | 9 | 11 | 29492 | 10 | |||
| 50049 | 223259 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003359.42366 | 2109144.63219 | 37.7714991343099 | -122.43176194386 | (37.7714991343099, -122.43176194386) | 15 | 9 | 11 | 29492 | 10 | |||
| 55577 | 47062 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | ||
| 75618 | 47063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | |||
| 98367 | 223261 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003316.11431 | 2109147.66446 | 37.7715050050806 | -122.431911969663 | (37.7715050050806, -122.431911969663) | 15 | 9 | 11 | 29492 | 10 | |||
| 102601 | 40616 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 298X Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 41623 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
| 108678 | 244958 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 270 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005192.4053 | 2109747.089 | 37.7732570676035 | -122.425464439836 | (37.7732570676035, -122.425464439836) | 7 | 9 | 11 | 28852 | 10 | |||
| 113277 | 42782 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42750 | 6005188.63098476 | 2109645.76261136 | 37.7729786366348 | -122.425470283277 | (37.7729786366348, -122.425470283277) | 7 | 9 | 11 | 28852 | 10 | |||
| 120424 | 47060 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 114 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | 7 | 9 | 11 | 28852 | 10 | |||
| 128834 | 223258 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003383.91707 | 2109145.40948 | 37.7715026569435 | -122.431677275407 | (37.7715026569435, -122.431677275407) | 15 | 9 | 11 | 29492 | 10 | |||
| 132658 | 40613 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 298X Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41623 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | ||||
| 153519 | 223260 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003343.49773 | 2109142.82285 | 37.7714932635271 | -122.431816903254 | (37.7714932635271, -122.431816903254) | 15 | 9 | 11 | 29492 | 10 | |||
| 172267 | 244962 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 202 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005157.1549 | 2109800.5724 | 37.7734019283256 | -122.425590183018 | (37.7734019283256, -122.425590183018) | 7 | 9 | 11 | 28852 | 10 | |||
| 176535 | 223097 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004260.2997 | 2109306.43724 | 37.7719944368218 | -122.428657301609 | (37.7719944368218, -122.428657301609) | 7 | 9 | 11 | 28852 | 10 | |||
| 180147 | 40615 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42266 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
| 43339 | 123459 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 473 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995269.10945 | 2112350.33897 | 37.7798392345462 | -122.459978845187 | (37.7798392345462, -122.459978845187) | 11 | 6 | 2 | 54 | 11 | |||
| 48740 | 52468 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 708@ CABRILLO 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 5 | Permit Number 48579 | 5993204.94393 | 2110626.22169 | 37.7749863407078 | -122.466994264438 | (37.7749863407078, -122.466994264438) | 11 | 6 | 2 | 54 | 11 | |
| 49859 | 39855 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 450 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 5 | Permit Number 41162 | 5992829.73528 | 2112398.7593 | 37.7798315856925 | -122.468421167303 | (37.7798315856925, -122.468421167303) | 11 | 6 | 2 | 54 | 11 | |
| 52403 | 82137 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
| 69078 | 124052 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 734 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992593.72624 | 2110428.27416 | 37.7744075323551 | -122.469094169847 | (37.7744075323551, -122.469094169847) | 11 | 6 | 2 | 54 | 11 | |||
| 82375 | 41930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 556 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42289 | 5994717.64459 | 2111772.42244 | 37.7782206983537 | -122.461844674778 | (37.7782206983537, -122.461844674778) | 11 | 6 | 2 | 54 | 11 | |
| 121227 | 82183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
| 122815 | 41958 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3520 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42314 | 5992457.73238 | 2110034.76352 | 37.773319199455 | -122.469535942454 | (37.773319199455, -122.469535942454) | 11 | 6 | 2 | 54 | 11 | |
| 127994 | 95817 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 275 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767555 | 5993331.8 | 2113672 | 37.7833565457315 | -122.466776900247 | (37.7833565457315, -122.466776900247) | 11 | 6 | 2 | 54 | 11 | |
| 130370 | 37597 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 734 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40024 | 5992595.59117005 | 2110448.7797774 | 37.7744639430104 | -122.469089211438 | (37.7744639430104, -122.469089211438) | 11 | 6 | 2 | 54 | 11 | ||
| 140337 | 82182 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
| 153415 | 41932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 568 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42291 | 5994718.86088 | 2111682.35233 | 37.7779734598848 | -122.461833934507 | (37.7779734598848, -122.461833934507) | 11 | 6 | 2 | 54 | 11 | |
| 179147 | 145306 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5992847.35421 | 2111936.76759 | 37.7785640995019 | -122.468326596707 | (37.7785640995019, -122.468326596707) | 11 | 6 | 2 | 54 | 11 | |||
| 181713 | 124088 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 601 Funston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5991897.07787 | 2111001.16091 | 37.7759402465292 | -122.471545739628 | (37.7759402465292, -122.471545739628) | 11 | 6 | 2 | 54 | 11 | ||||
| 12195 | 206712 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993729.968 | 2103029.70657 | 37.7541585918487 | -122.464626378423 | (37.7541585918487, -122.464626378423) | 1 | 8 | 4 | 56 | 12 | |||
| 12296 | 206714 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993663.54553 | 2103899.42942 | 37.7565427971281 | -122.464919240823 | (37.7565427971281, -122.464919240823) | 1 | 8 | 4 | 56 | 12 | |||
| 17766 | 94165 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53528 | 5993721 | 2103904 | 37.7565586593184 | -122.46472087623 | (37.7565586593184, -122.46472087623) | 1 | 8 | 4 | 56 | 12 | ||
| 23893 | 206710 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991484.15293 | 2106105.9073 | 37.7624753009047 | -122.472617151554 | (37.7624753009047, -122.472617151554) | 1 | 8 | 11 | 56 | 12 | |||
| 25089 | 206711 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1366 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991481.24454 | 2106127.13421 | 37.7625334160042 | -122.472628758222 | (37.7625334160042, -122.472628758222) | 1 | 8 | 11 | 56 | 12 | |||
| 28323 | 206708 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1926 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991286.95111 | 2102293.22218 | 37.7519952564944 | -122.473021145018 | (37.7519952564944, -122.473021145018) | 1 | 8 | 4 | 29491 | 12 | |||
| 33441 | 206753 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 355 Parnassus Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5996046.6732 | 2106441.49184 | 37.7636597709952 | -122.456861438509 | (37.7636597709952, -122.456861438509) | 15 | 5 | 4 | 29492 | 12 | |||
| 35038 | 206706 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.60294 | 2105348.51695 | 37.7603755269382 | -122.473767390769 | (37.7603755269382, -122.473767390769) | 1 | 8 | 4 | 56 | 12 | |||
| 36830 | 206713 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1835 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993730.54086 | 2103003.335 | 37.7540862153215 | -122.464622482542 | (37.7540862153215, -122.464622482542) | 1 | 8 | 4 | 56 | 12 | |||
| 39701 | 206703 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1917 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5990930.40398 | 2102318.91188 | 37.75204514457 | -122.474255998729 | (37.75204514457, -122.474255998729) | 1 | 8 | 4 | 29491 | 12 | |||
| 41560 | 206719 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5992799.45091 | 2104376.41203 | 37.757802607033 | -122.467942255237 | (37.757802607033, -122.467942255237) | 1 | 8 | 4 | 56 | 12 | |||
| 44807 | 121103 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 | |||
| 48363 | 206721 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1750 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.43392 | 2103566.80164 | 37.7556349000417 | -122.464570392019 | (37.7556349000417, -122.464570392019) | 1 | 8 | 4 | 56 | 12 | |||
| 48742 | 206724 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1758 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.36857 | 2103534.87932 | 37.7555472458103 | -122.464568300197 | (37.7555472458103, -122.464568300197) | 1 | 8 | 4 | 56 | 12 | |||
| 54230 | 206707 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991123.15013 | 2104471.83436 | 37.7579676676953 | -122.473746503093 | (37.7579676676953, -122.473746503093) | 1 | 8 | 4 | 56 | 12 | |||
| 60460 | 206705 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.43811 | 2105372.76647 | 37.7604421001312 | -122.473769729905 | (37.7604421001312, -122.473769729905) | 1 | 8 | 4 | 56 | 12 | |||
| 78622 | 206718 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1657 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993687.28793 | 2104194.62736 | 37.7573547032735 | -122.464858568992 | (37.7573547032735, -122.464858568992) | 1 | 8 | 4 | 56 | 12 | |||
| 80583 | 206720 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1734 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993752.64886 | 2103670.20251 | 37.7559185363224 | -122.464594447978 | (37.7559185363224, -122.464594447978) | 1 | 8 | 4 | 56 | 12 | |||
| 85469 | 206717 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1657 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5993684.72511 | 2104231.15464 | 37.7574548499695 | -122.464870084812 | (37.7574548499695, -122.464870084812) | 1 | 8 | 4 | 56 | 12 | |||
| 89824 | 206754 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1995 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991572.63095 | 2101920.9351 | 37.7509895886981 | -122.472006100028 | (37.7509895886981, -122.472006100028) | 1 | 8 | 4 | 29491 | 12 | |||
| 90628 | 206715 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993624.37216 | 2103900.25206 | 37.7565427971383 | -122.465054774977 | (37.7565427971383, -122.465054774977) | 1 | 8 | 4 | 56 | 12 | |||
| 93536 | 206739 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 496 Pacheco St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993527.20185 | 2101910.60143 | 37.7510741249729 | -122.465246305396 | (37.7510741249729, -122.465246305396) | 1 | 8 | 4 | 29491 | 12 | |||
| 97957 | 206722 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1754 08th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 5993756.80333 | 2103555.38299 | 37.7556035110194 | -122.464571743692 | (37.7556035110194, -122.464571743692) | 1 | 8 | 4 | 56 | 12 | |||
| 99071 | 206730 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993913.80681 | 2104584.90061 | 37.7584393504094 | -122.46410351439 | (37.7584393504094, -122.46410351439) | 1 | 8 | 4 | 56 | 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );