trees
713 rows where qSpecies_id = 102 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 24836 | 96563 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 567 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | Permit Number 767781 | 6007698 | 2096716 | 37.7376179219065 | -122.415874290579 | (37.7376179219065, -122.415874290579) | 2 | 7 | 7 | 28859 | 2 | ||||
| 109399 | 88090 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1875 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51093 | 5984391.2 | 2102428.5 | 37.7519650432303 | -122.49687727463 | (37.7519650432303, -122.49687727463) | 1 | 8 | 3 | 56 | 35 | |||
| 150183 | 87777 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 190 28th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50501 | 6004650.7 | 2099620.4 | 37.7454209537076 | -122.426617023323 | (37.7454209537076, -122.426617023323) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 646 | 223229 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004052.87626 | 2102494.4926 | 37.7532787266382 | -122.428889066793 | (37.7532787266382, -122.428889066793) | 2 | 4 | 5 | 28862 | 22 | |||
| 1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
| 1780 | 223125 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009223.64941 | 2102625.89478 | 37.7539308430518 | -122.411016683293 | (37.7539308430518, -122.411016683293) | 2 | 4 | 7 | 28859 | 19 | |||
| 1820 | 223236 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4537 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787681 | 6001259.34989 | 2104046.86599 | 37.7573826560002 | -122.438660858237 | (37.7573826560002, -122.438660858237) | 2 | 4 | 5 | 28862 | 3 | |
| 1861 | 65043 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 744 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 26096 | 5982313.7707 | 2110666.72217 | 37.7744628966917 | -122.504671542451 | (37.7744628966917, -122.504671542451) | 11 | 6 | 2 | 55 | 26 | ||
| 2625 | 161272 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 562 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:33:00 PM | 3 | Width 0ft | 6002894.24566 | 2090355.62698 | 37.719882537321 | -122.432029089275 | (37.719882537321, -122.432029089275) | 9 | 7 | 6 | 28861 | 5 | |
| 3123 | 261802 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2319 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986356 | 2099450 | 37.7439018196285 | -122.489863769411 | (37.7439018196285, -122.489863769411) | 1 | 8 | 3 | 29491 | 35 | ||
| 3902 | 223217 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1191 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003256 | 2101366 | 37.75013501563 | -122.431564267794 | (37.75013501563, -122.431564267794) | 2 | 4 | 5 | 28862 | 22 | |||
| 4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 4149 | 169685 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2585 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002269.97794 | 2096798.3861 | 37.7375374800648 | -122.43464741415 | (37.7375374800648, -122.43464741415) | 2 | 7 | 5 | 63 | 7 | |||
| 4325 | 261136 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4200 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | 3x3 | 6003439 | 2093988 | 37.729887093701 | -122.43040509359 | (37.729887093701, -122.43040509359) | 9 | 7 | 6 | 28861 | 25 | ||
| 4450 | 95446 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.492093817749 | (37.7458386996409, -122.492093817749) | 1 | 8 | 3 | 29491 | 35 |
| 4742 | 243755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 51 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002062.89469 | 2096349.46794 | 37.7362930962328 | -122.43533129551 | (37.7362930962328, -122.43533129551) | 2 | 7 | 5 | 63 | 7 | |||
| 4932 | 37209 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1915 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39775 | 5986283.2112 | 2102182.1445 | 37.7513993005965 | -122.490316396609 | (37.7513993005965, -122.490316396609) | 1 | 8 | 3 | 29491 | 35 | |
| 5030 | 171365 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002871.58236 | 2093130.52409 | 37.7275005001327 | -122.432305504906 | (37.7275005001327, -122.432305504906) | 9 | 7 | 6 | 28861 | 5 | ||
| 5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
| 5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 6404 | 73766 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3834 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996504.18251 | 2114976.06965 | 37.7871197485358 | -122.45589607746 | (37.7871197485358, -122.45589607746) | 11 | 6 | 1 | 54 | 31 | |||
| 7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
| 8484 | 180531 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 401 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 4 | Width 2ft | 6002788.2945 | 2090951.75373 | 37.721513361625 | -122.432437880612 | (37.721513361625, -122.432437880612) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |
| 8537 | 78846 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.469225944831 | (37.7092849811889, -122.469225944831) | 9 | 8 | 4 | 64 | 24 | |||
| 8633 | 264870 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1674 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985361 | 2103822 | 37.755847989753 | -122.493626286002 | (37.755847989753, -122.493626286002) | 1 | 8 | 3 | 56 | 35 | ||
| 9146 | 32509 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 718 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 6 | 2.5x3 | Permit Number 37011 | 6007605.33765 | 2096031.84482 | 37.7357341720927 | -122.416146230064 | (37.7357341720927, -122.416146230064) | 2 | 7 | 7 | 28859 | 2 |
| 9182 | 223199 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2957 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009122.48149 | 2102727.86117 | 37.7542051461569 | -122.411373750107 | (37.7542051461569, -122.411373750107) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 12117 | 223149 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3925 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002289.78631 | 2103524.74331 | 37.7560075979872 | -122.435059863923 | (37.7560075979872, -122.435059863923) | 2 | 4 | 5 | 28862 | 22 | ||||
| 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 | |||
| 12335 | 32449 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4351 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 4 | Permit Number 36968 | 6000424.87812 | 2105754.35735 | 37.7620235013126 | -122.441669319785 | (37.7620235013126, -122.441669319785) | 15 | 5 | 5 | 28862 | 3 | |
| 12597 | 144628 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 5988384.27006 | 2114435.54017 | 37.7851662339868 | -122.4839491984 | (37.7851662339868, -122.4839491984) | 11 | 6 | 2 | 55 | 26 | |||
| 13116 | 49003 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 428 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | 6 | Permit Number 46190 | 6003609.57090194 | 2102180.87163122 | 37.7523924957508 | -122.430399732377 | (37.7523924957508, -122.430399732377) | 2 | 4 | 5 | 28862 | 22 | |
| 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 |
| 13635 | 261439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 374x Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
| 13687 | 223210 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4096 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003278.99066 | 2101283.19814 | 37.749908964249 | -122.431478854381 | (37.749908964249, -122.431478854381) | 2 | 4 | 5 | 28862 | 22 | |||
| 14186 | 261520 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 750 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2020 12:24:00 PM | 5982933.06329 | 2110647.13754 | 37.7744455330351 | -122.502527876502 | (37.7744455330351, -122.502527876502) | 11 | 6 | 2 | 55 | 26 | |||
| 14770 | 223263 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1713 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003981.90505 | 2098315.20086 | 37.7417993447574 | -122.42883657696 | (37.7417993447574, -122.42883657696) | 2 | 7 | 5 | 63 | 7 | |||
| 15984 | 52285 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 49 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48443 | 6005568.13669376 | 2099312.5052799 | 37.7446273691442 | -122.423422786255 | (37.7446273691442, -122.423422786255) | 2 | 7 | 5 | 28859 | 22 | ||
| 15986 | 55366 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | Permit Number 46504 | 5993337.43694089 | 2094535.94135118 | 37.7308142184714 | -122.465366881335 | (37.7308142184714, -122.465366881335) | 9 | 8 | 4 | 59 | 40 | ||
| 16997 | 38011 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2537 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40222 | 5991707.38932153 | 2098162.62971781 | 37.7406780464622 | -122.471266299952 | (37.7406780464622, -122.471266299952) | 1 | 8 | 4 | 29491 | 40 | ||
| 17578 | 223163 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 220 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008988.9604 | 2097329.9937 | 37.7393763076577 | -122.411454173775 | (37.7393763076577, -122.411454173775) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |
| 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 | ||
| 18133 | 48935 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46123 | 6008967.24880953 | 2102489.58925571 | 37.7535421972635 | -122.411893748881 | (37.7535421972635, -122.411893748881) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 18239 | 120242 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 288 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988397.89946 | 2114035.20565 | 37.7840678224086 | -122.483872680677 | (37.7840678224086, -122.483872680677) | 11 | 6 | 2 | 55 | 26 | |||
| 18332 | 223062 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 257 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007025.24447 | 2107893.6932 | 37.7682714683756 | -122.41899290632 | (37.7682714683756, -122.41899290632) | 8 | 4 | 7 | 28853 | 19 | |||
| 18412 | 147497 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 4ft | 5989658.48818 | 2112247.31744 | 37.7792320844204 | -122.479380704451 | (37.7792320844204, -122.479380704451) | 11 | 6 | 2 | 55 | 26 | ||
| 19006 | 259153 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 207 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007591 | 2097689 | 37.7402835491894 | -122.416313137546 | (37.7402835491894, -122.416313137546) | 2 | 7 | 7 | 28859 | 2 | ||||
| 19146 | 223231 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004263.07305 | 2103628.9074 | 37.7564054580508 | -122.428243005513 | (37.7564054580508, -122.428243005513) | 2 | 4 | 5 | 28862 | 22 | |||
| 19525 | 118867 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 686 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981365.93161 | 2111081.95893 | 37.7755472130957 | -122.507981064387 | (37.7755472130957, -122.507981064387) | 11 | 6 | 2 | 55 | 26 | ||
| 19857 | 223198 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2901 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009412.47335 | 2102745.855 | 37.7542708137705 | -122.410372152653 | (37.7542708137705, -122.410372152653) | 2 | 4 | 7 | 28859 | 19 | |||
| 19895 | 223061 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3705 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005700.15311 | 2101372.39104 | 37.750290794794 | -122.423112686203 | (37.750290794794, -122.423112686203) | 2 | 4 | 5 | 28859 | 19 | |||
| 20837 | 39081 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 816 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40779 | 6009882.35970531 | 2104453.69348919 | 37.758986484759 | -122.408867645938 | (37.758986484759, -122.408867645938) | 2 | 4 | 7 | 28859 | 19 | ||
| 20965 | 37421 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39901 | 6003240.50544879 | 2101168.34074207 | 37.7495914114978 | -122.431603738981 | (37.7495914114978, -122.431603738981) | 2 | 4 | 5 | 28862 | 22 | ||
| 21503 | 223143 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 605 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002444.15174 | 2102068.56819 | 37.7520180525139 | -122.434421909144 | (37.7520180525139, -122.434421909144) | 2 | 4 | 5 | 28862 | 22 | |||
| 21672 | 36567 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39429 | 6006271.54294487 | 2096111.84764875 | 37.7358787559596 | -122.420763362902 | (37.7358787559596, -122.420763362902) | 2 | 7 | 7 | 28859 | 2 | ||
| 22064 | 113315 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2493x 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984243.3692 | 2098259.1068 | 37.7405083669922 | -122.497080760951 | (37.7405083669922, -122.497080760951) | 1 | 8 | 3 | 29491 | 35 | |||
| 22791 | 126391 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5997748.40757 | 2115473.64195 | 37.7885572815394 | -122.451627258297 | (37.7885572815394, -122.451627258297) | 11 | 6 | 1 | 54 | 31 | |||
| 23347 | 206742 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5997796.56298 | 2094976.80615 | 37.7322808851511 | -122.449982803857 | (37.7322808851511, -122.449982803857) | 9 | 7 | 4 | 59 | 40 | |||
| 23447 | 37412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 920 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39890 | 6001892.73765623 | 2101410.4821696 | 37.7501797894928 | -122.436281684424 | (37.7501797894928, -122.436281684424) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 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 |
| 24421 | 206756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991004.48671 | 2100128.5419 | 37.7460352505192 | -122.473840030798 | (37.7460352505192, -122.473840030798) | 1 | 8 | 4 | 29491 | 40 | |||
| 24521 | 34871 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 362 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39900 | 6002791.72644386 | 2101550.82973484 | 37.7506161886226 | -122.433182956314 | (37.7506161886226, -122.433182956314) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 24895 | 35947 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39109 | 6007155.94334709 | 2095722.46816688 | 37.734859413246 | -122.417678043362 | (37.734859413246, -122.417678043362) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 26030 | 206732 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2430 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991403.39763 | 2098862.37414 | 37.7425817765239 | -122.472368375716 | (37.7425817765239, -122.472368375716) | 1 | 8 | 4 | 29491 | 40 | |||
| 26169 | 206759 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995896.88081 | 2094136.36483 | 37.7298643528405 | -122.456489645298 | (37.7298643528405, -122.456489645298) | 9 | 7 | 4 | 28861 | 40 | |||
| 26568 | 223100 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 323 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003606.73212 | 2099501.75827 | 37.7450361154323 | -122.43021843293 | (37.7450361154323, -122.43021843293) | 2 | 7 | 5 | 63 | 22 | |||
| 26989 | 42903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42817 | 6007744.73028146 | 2104990.07889872 | 37.7603393072133 | -122.416298586055 | (37.7603393072133, -122.416298586055) | 2 | 4 | 7 | 28859 | 19 | ||
| 27308 | 206763 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995815.46326 | 2094322.90602 | 37.7303718753392 | -122.456784599525 | (37.7303718753392, -122.456784599525) | 9 | 7 | 4 | 28861 | 40 | |||
| 27660 | 36691 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 15 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39490 | 6005970.65710535 | 2105699.54901563 | 37.7621874267643 | -122.42248469974 | (37.7621874267643, -122.42248469974) | 8 | 4 | 5 | 28859 | 19 | ||
| 27807 | 37883 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
| 28427 | 126393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 405 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998114.64668 | 2115082.3398 | 37.7875038363742 | -122.450331914389 | (37.7875038363742, -122.450331914389) | 11 | 6 | 1 | 54 | 31 | |||
| 29257 | 37356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Florentine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39862 | 5999496.07093 | 2087702.97116 | 37.7124057060181 | -122.443584900943 | (37.7124057060181, -122.443584900943) | 9 | 7 | 6 | 28861 | 5 | |
| 29702 | 223141 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4644 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000468.40561 | 2101124.67323 | 37.7493139961397 | -122.441186594305 | (37.7493139961397, -122.441186594305) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||
| 30784 | 84349 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50602 | 6006744.47832295 | 2104177.6342219 | 37.758052226043 | -122.419700351439 | (37.758052226043, -122.419700351439) | 2 | 4 | 7 | 28859 | 19 | ||
| 32339 | 223182 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006910.11223 | 2097068.32628 | 37.7385410056619 | -122.41862337757 | (37.7385410056619, -122.41862337757) | 2 | 7 | 7 | 28859 | 2 | |||
| 32362 | 206744 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 360 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997700.14288 | 2093824.21589 | 37.7291106283493 | -122.450233097774 | (37.7291106283493, -122.450233097774) | 9 | 7 | 4 | 28861 | 40 | |||
| 32480 | 51271 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 762 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 3 | Permit Number 47646 | 5991020.68747 | 2110207.63616 | 37.7737107039086 | -122.474519447105 | (37.7737107039086, -122.474519447105) | 11 | 6 | 2 | 54 | 26 | |
| 34656 | 223146 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003344.33647 | 2099293.67104 | 37.7444498905663 | -122.431110900363 | (37.7444498905663, -122.431110900363) | 2 | 7 | 5 | 63 | 22 | |||
| 35886 | 42461 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 638 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42603 | 5997203.88330057 | 2095296.86249192 | 37.7331257521174 | -122.45205490562 | (37.7331257521174, -122.45205490562) | 9 | 7 | 4 | 59 | 40 | ||
| 35923 | 40727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2002 12:00:00 AM | Permit Number 41706 | 6008971.38235478 | 2097242.21876487 | 37.7391343108464 | -122.411508751405 | (37.7391343108464, -122.411508751405) | 10 | 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 | ||
| 36636 | 223184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006986.80584 | 2097054.98835 | 37.7385087002251 | -122.418357261872 | (37.7385087002251, -122.418357261872) | 2 | 7 | 7 | 28859 | 2 | |||
| 36656 | 50121 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 251 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46844 | 5992306.20915001 | 2097823.24522432 | 37.7397808029858 | -122.469171133031 | (37.7397808029858, -122.469171133031) | 1 | 8 | 4 | 59 | 40 | ||
| 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 | |||
| 37017 | 223065 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 436 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005845.27485 | 2107876.32583 | 37.7681572661617 | -122.423073077374 | (37.7681572661617, -122.423073077374) | 8 | 4 | 5 | 28853 | 19 | |||
| 37595 | 206755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991006.69103 | 2100092.27446 | 37.7459357971944 | -122.473829763244 | (37.7459357971944, -122.473829763244) | 1 | 8 | 4 | 29491 | 40 | |||
| 37717 | 35412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38867 | 6003346.45221762 | 2099263.3283709 | 37.7443666965298 | -122.431101419272 | (37.7443666965298, -122.431101419272) | 2 | 7 | 5 | 63 | 22 |
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) );