trees
713 rows where qSpecies_id = 102 sorted by Longitude
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 | |||||||||||||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
| 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 |
| 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 |
| 67391 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 92116 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 182808 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 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 |
| 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 |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 135307 | 40184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1402 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 3 | 9x6 | Permit Number 41371 | 6013366.18337 | 2105703.90093 | 37.7626138064095 | -122.396906512841 | (37.7626138064095, -122.396906512841) | 14 | 3 | 8 | 28856 | 29 | |
| 29107 | 190945 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013445.03636 | 2110888.0497 | 37.7768527094247 | -122.396997287698 | (37.7768527094247, -122.396997287698) | 6 | 2 | 9 | 28856 | 34 | |||
| 20547 | 190947 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6013395.86609 | 2110840.5938 | 37.7767196691005 | -122.397164055286 | (37.7767196691005, -122.397164055286) | 6 | 2 | 9 | 28856 | 34 | |||
| 28151 | 190948 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013368.27074 | 2110817.70841 | 37.7766552947402 | -122.397257911242 | (37.7766552947402, -122.397257911242) | 6 | 2 | 9 | 28856 | 34 | |||
| 20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 55677 | 103442 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 73475 | 103443 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 81028 | 103428 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 83968 | 103448 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 25 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 92337 | 103429 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 111529 | 103439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 122814 | 103435 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 159372 | 103433 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 160032 | 103444 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 21 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 165939 | 103440 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 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 | |||
| 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 | |||
| 17734 | 47651 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 363 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 4 | Permit Number 45455 | 6012960.30928 | 2105372.99833 | 37.761682620471 | -122.3982870765 | (37.761682620471, -122.3982870765) | 10 | 3 | 8 | 28856 | 29 | |
| 116670 | 49954 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1704@ ARKANSAS 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 2 | 3x3 | Permit Number 46735 | 6012896.20183 | 2104748.72577 | 37.7599649342604 | -122.39846499386 | (37.7599649342604, -122.39846499386) | 10 | 3 | 8 | 28856 | 29 |
| 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 | |||
| 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 | |||
| 104003 | 39545 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52628 | 6012317.54572 | 2103734.07541 | 37.7571466747898 | -122.40039502803 | (37.7571466747898, -122.40039502803) | 10 | 3 | 8 | 28856 | 29 | |
| 123570 | 190938 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012303.18984 | 2103733.08208 | 37.7571431467556 | -122.400444606729 | (37.7571431467556, -122.400444606729) | 10 | 3 | 8 | 28856 | 29 | |||
| 37015 | 39548 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
| 92271 | 39546 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
| 158047 | 39547 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
| 79480 | 190937 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6012285.9595 | 2103731.71906 | 37.7571384433095 | -122.400504100505 | (37.7571384433095, -122.400504100505) | 10 | 3 | 8 | 28856 | 29 | |||
| 24718 | 190936 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012268.87212 | 2103730.35281 | 37.7571337389375 | -122.400563099634 | (37.7571337389375, -122.400563099634) | 10 | 3 | 8 | 28856 | 29 | |||
| 36801 | 39544 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52628 | 6012257.26801 | 2103730.73131 | 37.7571341310464 | -122.400603257944 | (37.7571341310464, -122.400603257944) | 10 | 3 | 8 | 28856 | 29 | |
| 145281 | 39543 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52628 | 6012246.93603 | 2103730.22749 | 37.7571321714345 | -122.400638954732 | (37.7571321714345, -122.400638954732) | 10 | 3 | 8 | 28856 | 29 | |
| 79677 | 39542 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52628 | 6012231.74927 | 2103730.67877 | 37.757132563538 | -122.400691508412 | (37.757132563538, -122.400691508412) | 10 | 3 | 8 | 28856 | 29 | |
| 31335 | 42183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
| 185180 | 42184 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
| 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 | |
| 65127 | 190935 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011029.84564 | 2104766.51746 | 37.7599096376513 | -122.404921103652 | (37.7599096376513, -122.404921103652) | 10 | 3 | 8 | 28856 | 29 | |||
| 79180 | 223095 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010627.88786 | 2100222.73921 | 37.7474109515518 | -122.405991188956 | (37.7474109515518, -122.405991188956) | 2 | 7 | 7 | 28859 | 2 | |||
| 190376 | 45191 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 362 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44034 | 6010581.515091 | 2099593.27903158 | 37.7456799974256 | -122.406107204455 | (37.7456799974256, -122.406107204455) | 2 | 7 | 7 | 28859 | 2 | ||
| 36056 | 83944 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2619 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52652 | 6010400.97039498 | 2103382.22541329 | 37.7560735087835 | -122.406998516177 | (37.7560735087835, -122.406998516177) | 10 | 4 | 7 | 28859 | 19 | ||
| 166140 | 223190 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010325.13431 | 2099720.24071 | 37.7460142630486 | -122.407002682534 | (37.7460142630486, -122.407002682534) | 2 | 7 | 7 | 28859 | 2 | |||
| 44862 | 114642 | Private 9 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163197 | -122.407019863158 | (37.745978163197, -122.407019863158) | 2 | 7 | 7 | 28859 | 2 | |||
| 134039 | 223090 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010331.77576 | 2101864.81517 | 37.7519031650082 | -122.407130859298 | (37.7519031650082, -122.407130859298) | 10 | 4 | 7 | 28859 | 19 | |||
| 149758 | 223091 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010331.58374 | 2101901.50724 | 37.7520039025724 | -122.407134109472 | (37.7520039025724, -122.407134109472) | 10 | 4 | 7 | 28859 | 19 | |||
| 134972 | 223072 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2619 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010338.49274 | 2103381.65563 | 37.7560684479069 | -122.407214545709 | (37.7560684479069, -122.407214545709) | 10 | 4 | 7 | 28859 | 19 | |||
| 163741 | 223071 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2637 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010290.16731 | 2103379.94771 | 37.7560610536772 | -122.407381551617 | (37.7560610536772, -122.407381551617) | 10 | 4 | 7 | 28859 | 19 | |||
| 120465 | 47321 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1417 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45249 | 6010127.95501963 | 2100968.14879638 | 37.7494297087612 | -122.407772483241 | (37.7494297087612, -122.407772483241) | 2 | 4 | 7 | 28859 | 19 | ||
| 190643 | 34345 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39472 | 6010117.3573919 | 2101160.06487497 | 37.7499560747185 | -122.407822661385 | (37.7499560747185, -122.407822661385) | 2 | 4 | 7 | 28859 | 19 | ||
| 136121 | 223084 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010107.30184 | 2101158.22859 | 37.7499504697387 | -122.407857304679 | (37.7499504697387, -122.407857304679) | 2 | 4 | 7 | 28859 | 19 | |||
| 28412 | 223085 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010105.40683 | 2101175.29906 | 37.7499972353919 | -122.407865061343 | (37.7499972353919, -122.407865061343) | 2 | 4 | 7 | 28859 | 19 | |||
| 164119 | 223083 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1444 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6010087.8553 | 2100823.29254 | 37.7490297204664 | -122.407900936194 | (37.7490297204664, -122.407900936194) | 2 | 4 | 7 | 28859 | 19 | |||
| 152542 | 223082 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1438 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010087.31315 | 2100865.46474 | 37.7491454856861 | -122.407905784439 | (37.7491454856861, -122.407905784439) | 2 | 4 | 7 | 28859 | 19 | |||
| 60958 | 52170 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1438 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48363 | 6010081.42720851 | 2100867.61644364 | 37.7491510642606 | -122.407926289907 | (37.7491510642606, -122.407926289907) | 2 | 4 | 7 | 28859 | 19 | ||
| 122824 | 223086 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1325 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010089.04451 | 2101486.66986 | 37.7508512747783 | -122.407943598216 | (37.7508512747783, -122.407943598216) | 2 | 4 | 7 | 28859 | 19 | |||
| 81450 | 223081 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1384 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010072.14302 | 2101152.80267 | 37.7499336029604 | -122.40797850361 | (37.7499336029604, -122.40797850361) | 2 | 4 | 7 | 28859 | 19 | |||
| 77212 | 223080 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1384 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010069.44691 | 2101171.84384 | 37.749985734861 | -122.407989169564 | (37.749985734861, -122.407989169564) | 2 | 4 | 7 | 28859 | 19 | |||
| 127148 | 47319 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45247 | 6010064.213398 | 2102122.46814507 | 37.7525956457459 | -122.408074300806 | (37.7525956457459, -122.408074300806) | 2 | 4 | 7 | 28859 | 19 | ||
| 102589 | 39198 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1213 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | Permit Number 46144 | 6010063.59711896 | 2102133.62856163 | 37.7526262552662 | -122.408077219023 | (37.7526262552662, -122.408077219023) | 2 | 4 | 7 | 28859 | 19 | ||
| 185118 | 223087 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010059.28582 | 2102034.7941 | 37.752354636379 | -122.408085158703 | (37.752354636379, -122.408085158703) | 2 | 4 | 7 | 28859 | 19 | |||
| 104127 | 223088 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1213 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010058.98146 | 2102047.36432 | 37.7523891343723 | -122.408087097659 | (37.7523891343723, -122.408087097659) | 2 | 4 | 7 | 28859 | 19 |
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) );