trees
493 rows where qSpecies_id = 133 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6774 | 249677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 9 | Front Yard : Yard | Tree | Private 2 | 9 | 5999741.70445 | 2117184.69909 | 37.7933693451834 | -122.444853823654 | (37.7933693451834, -122.444853823654) | 13 | 9 | 1 | 57 | 27 | ||||
| 8188 | 126379 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | 5 | 1 | 1 | 28858 | 32 | |||
| 14146 | 41229 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41935 | 6002621.77288 | 2121066.97203 | 37.8041929962699 | -122.435166401228 | (37.8041929962699, -122.435166401228) | 13 | 9 | 1 | 57 | 17 |
| 48670 | 249686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 18 | Front Yard : Yard | Tree | Private 2 | 4 | 5999708.23219 | 2117360.34158 | 37.7938497027636 | -122.444982272037 | (37.7938497027636, -122.444982272037) | 13 | 9 | 1 | 57 | 27 | ||||
| 48825 | 116196 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
| 52088 | 126383 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1116 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | 5 | 1 | 1 | 28858 | 32 | ||||
| 55830 | 41230 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41935 | 6002625.18254 | 2121047.68706 | 37.804140238442 | -122.435153221671 | (37.804140238442, -122.435153221671) | 13 | 9 | 1 | 57 | 17 |
| 59033 | 126376 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001336.2876 | 2121154.5777 | 37.8043604581295 | -122.439621194774 | (37.8043604581295, -122.439621194774) | 13 | 9 | 1 | 57 | 17 | |||
| 114901 | 126377 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001345.97363 | 2121147.25207 | 37.8043408951819 | -122.439587150049 | (37.8043408951819, -122.439587150049) | 13 | 9 | 1 | 57 | 17 | |||
| 117769 | 126378 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | 13 | 9 | 1 | 57 | 17 | |||
| 164255 | 126380 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.7997755425663 | -122.418126178374 | (37.7997755425663, -122.418126178374) | 5 | 1 | 1 | 28858 | 32 | |||
| 184572 | 50986 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1120REVISED Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2004 12:00:00 AM | 6 | Permit Number 47576 | 6007503.31376 | 2119893.93908 | 37.801248132044 | -122.418190201138 | (37.801248132044, -122.418190201138) | 5 | 1 | 1 | 28858 | 32 | ||
| 187759 | 126384 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1120 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6007500.24433 | 2119896.23774 | 37.8012542708165 | -122.418200985801 | (37.8012542708165, -122.418200985801) | 5 | 1 | 1 | 28858 | 32 | ||||
| 189944 | 116195 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
| 190535 | 249691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 23 | Front Yard : Yard | Tree | Private 2 | 1 | 5999714.93782 | 2117284.79533 | 37.793642655433 | -122.444953636697 | (37.793642655433, -122.444953636697) | 13 | 9 | 1 | 57 | 27 | ||||
| 10533 | 71420 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | 3 | 1 | 10 | 308 | 23 | |||
| 32357 | 126382 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1001 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6008670.39988 | 2118624.74661 | 37.7978288673746 | -122.414061717575 | (37.7978288673746, -122.414061717575) | 5 | 1 | 10 | 308 | 21 | |||
| 42279 | 126381 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1022 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6008596.52569 | 2118672.84077 | 37.7979567725457 | -122.414320748412 | (37.7979567725457, -122.414320748412) | 5 | 1 | 10 | 308 | 21 | ||||
| 47893 | 62968 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1136 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23354 | 6007556.73602589 | 2118875.23289672 | 37.7984540273893 | -122.417933081039 | (37.7984540273893, -122.417933081039) | 5 | 1 | 10 | 28858 | 32 | ||
| 54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
| 90233 | 108929 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 12x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008556.45633 | 2119171.57464 | 37.7993239210113 | -122.414494709684 | (37.7993239210113, -122.414494709684) | 5 | 1 | 10 | 308 | 32 | |||
| 95062 | 62709 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.7982515357622 | -122.418390975112 | (37.7982515357622, -122.418390975112) | 5 | 1 | 10 | 28858 | 32 | ||
| 7001 | 225622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 67 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997067.03037 | 2106173.30325 | 37.7629819312842 | -122.453312997018 | (37.7629819312842, -122.453312997018) | 15 | 5 | 11 | 29492 | 12 | |||
| 10122 | 52665 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815 | 2109317 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | 15 | 5 | 11 | 29492 | 9 | |
| 18339 | 70315 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 226 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997860.8667 | 2109778.6627 | 37.7729267975155 | -122.450827376517 | (37.7729267975155, -122.450827376517) | 15 | 5 | 11 | 29492 | 16 | |||
| 47942 | 48500 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1584(REVISED) Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46340 | 5998006.8549345 | 2108237.90665559 | 37.7687046321234 | -122.450211308243 | (37.7687046321234, -122.450211308243) | 15 | 5 | 11 | 29492 | 9 | |||
| 55106 | 102412 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
| 72234 | 43002 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
| 74334 | 244873 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | 15 | 5 | 11 | 29492 | 9 | |||
| 74617 | 206562 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.7608732027602 | -122.462785287235 | (37.7608732027602, -122.462785287235) | 1 | 5 | 11 | 56 | 12 | |||
| 91240 | 51948 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48172 | 5996897.19536074 | 2106034.05471344 | 37.7625898542367 | -122.453890338129 | (37.7625898542367, -122.453890338129) | 15 | 5 | 11 | 29492 | 12 | ||||
| 111111 | 137657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.7788044135747 | -122.444756988886 | (37.7788044135747, -122.444756988886) | 15 | 5 | 11 | 29490 | 16 | |||
| 115810 | 63593 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24225 | 6005185.44614551 | 2109584.80310454 | 37.7728110766439 | -122.425476960922 | (37.7728110766439, -122.425476960922) | 7 | 9 | 11 | 28852 | 10 | ||
| 118642 | 137632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.444896086774 | (37.7787937523144, -122.444896086774) | 15 | 5 | 11 | 29490 | 16 | |||
| 119257 | 223030 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.7595064230002 | -122.450164233094 | (37.7595064230002, -122.450164233094) | 15 | 5 | 11 | 28862 | 12 | |||
| 140400 | 223031 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 38 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998471.48427 | 2106911.98504 | 37.7650905653978 | -122.448508695418 | (37.7650905653978, -122.448508695418) | 15 | 5 | 11 | 29492 | 9 | |||
| 146731 | 223028 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998401.23132 | 2106021.8866 | 37.7626425622232 | -122.448687567871 | (37.7626425622232, -122.448687567871) | 15 | 5 | 11 | 29492 | 9 | |||
| 160958 | 46178 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 36 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44505 | 5998475.49358611 | 2106915.81544951 | 37.7651013119743 | -122.448495104116 | (37.7651013119743, -122.448495104116) | 15 | 5 | 11 | 29492 | 9 | ||
| 165895 | 42999 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
| 192064 | 223029 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997728.70717 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | 15 | 5 | 11 | 29492 | 12 | |||
| 192920 | 64244 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 554 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33284 | 6005149.6274741 | 2111313.35504132 | 37.7775552357395 | -122.425723916077 | (37.7775552357395, -122.425723916077) | 7 | 9 | 11 | 28852 | 10 | ||
| 4849 | 43803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.482009746097 | (37.7733720498685, -122.482009746097) | 11 | 6 | 2 | 55 | 26 | ||
| 82530 | 68702 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | 11 | 6 | 2 | 54 | 11 | ||
| 99436 | 47077 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | Permit Number 45064 | 5996788.5617 | 2112098.8644 | 37.7792360227866 | -122.454704245524 | (37.7792360227866, -122.454704245524) | 15 | 6 | 2 | 54 | 16 | |
| 146015 | 68553 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | 11 | 6 | 2 | 55 | 26 | ||
| 156649 | 251254 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 09th Ave | 1 | unknown : Cutout | Tree | MTA 3 | 3x3 | 5993109 | 2113253 | 37.7821932251036 | -122.467517213871 | (37.7821932251036, -122.467517213871) | 11 | 6 | 2 | 54 | 11 | ||||
| 170237 | 141302 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 208 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998449.1975 | 2112684.3341 | 37.7809386817499 | -122.449001631605 | (37.7809386817499, -122.449001631605) | 15 | 6 | 2 | 54 | 16 | |||
| 701 | 52560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.7543488257224 | -122.497901608629 | (37.7543488257224, -122.497901608629) | 1 | 8 | 3 | 56 | 35 | |
| 1328 | 65972 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1990 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.7486477564753 | -122.480306841406 | (37.7486477564753, -122.480306841406) | 1 | 8 | 3 | 29491 | 35 | |
| 9249 | 183317 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.500875914404 | (37.7640002060456, -122.500875914404) | 1 | 8 | 3 | 56 | 35 | |||
| 10338 | 31751 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | 1 | 8 | 3 | 29491 | 35 | |
| 18348 | 98409 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 55 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||||
| 23516 | 50918 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | 1 | 8 | 3 | 29491 | 35 | |
| 33901 | 183040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | 1 | 8 | 3 | 29491 | 35 | |||
| 47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
| 55272 | 95906 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) | 1 | 8 | 3 | 56 | 35 |
| 89550 | 65967 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | 1 | 8 | 3 | 29491 | 35 | |
| 104910 | 31750 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | 1 | 8 | 3 | 29491 | 35 | |
| 110106 | 63000 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.7632845753318 | -122.501897691969 | (37.7632845753318, -122.501897691969) | 1 | 8 | 3 | 56 | 35 | ||
| 110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
| 119747 | 38530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | 1 | 8 | 3 | 29491 | 35 | ||
| 123013 | 31753 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | 1 | 8 | 3 | 29491 | 35 | |
| 123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
| 132897 | 61351 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2435 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33180 | 5983606.72733818 | 2098575.39773775 | 37.7413394866654 | -122.499305352528 | (37.7413394866654, -122.499305352528) | 1 | 8 | 3 | 29491 | 35 | ||
| 138408 | 82688 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | 1 | 8 | 3 | 56 | 35 | |
| 144997 | 69148 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | 1 | 8 | 3 | 29491 | 35 | ||
| 146470 | 63003 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1239 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23411 | 5983024.3565 | 2106665.5091 | 37.763518489811 | -122.501917412441 | (37.763518489811, -122.501917412441) | 1 | 8 | 3 | 56 | 35 | ||
| 168589 | 183679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.496998863919 | (37.7626128114068, -122.496998863919) | 1 | 8 | 3 | 56 | 35 | |||
| 170107 | 95910 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.7524679589822 | -122.490396818222 | (37.7524679589822, -122.490396818222) | 1 | 8 | 3 | 56 | 35 |
| 171037 | 182595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.7466767317389 | -122.4767165565 | (37.7466767317389, -122.4767165565) | 1 | 8 | 3 | 29491 | 35 | |||
| 179616 | 63086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1986 12:00:00 AM | 3 | Permit Number 23570 | 5983326.3714 | 2106866.623 | 37.7640884282736 | -122.500887729919 | (37.7640884282736, -122.500887729919) | 1 | 8 | 3 | 56 | 35 | ||
| 8549 | 206676 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | 9 | 7 | 4 | 59 | 40 | |||
| 9241 | 65804 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.473841275381 | (37.7459566686168, -122.473841275381) | 1 | 8 | 4 | 29491 | 40 | ||
| 9795 | 94076 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
| 11337 | 206619 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994070.38957 | 2104649.56309 | 37.7586259201623 | -122.463566678468 | (37.7586259201623, -122.463566678468) | 1 | 5 | 4 | 56 | 12 | |||
| 12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
| 13396 | 42456 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.7331328776169 | -122.450478486701 | (37.7331328776169, -122.450478486701) | 9 | 7 | 4 | 59 | 40 | ||
| 13518 | 31915 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | 1 | 8 | 4 | 29491 | 40 | |
| 14448 | 206509 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.7579816107664 | -122.474384202485 | (37.7579816107664, -122.474384202485) | 1 | 8 | 4 | 56 | 12 | |||
| 16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
| 17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
| 18421 | 122404 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
| 19680 | 206561 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995302.34368 | 2095238.16689 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | 9 | 7 | 4 | 59 | 40 | |||
| 20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 | |||
| 20681 | 206679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | 9 | 7 | 4 | 59 | 40 | |||
| 21541 | 206683 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995995.17419 | 2096006.34018 | 37.7350044954584 | -122.456284991974 | (37.7350044954584, -122.456284991974) | 9 | 7 | 4 | 59 | 40 | |||
| 21549 | 94071 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
| 22339 | 206516 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991047.26108 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | 1 | 8 | 4 | 56 | 12 | |||
| 24681 | 206641 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.7480798753848 | -122.462020618849 | (37.7480798753848, -122.462020618849) | 1 | 8 | 4 | 29491 | 40 | |||
| 25175 | 65811 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | 1 | 8 | 4 | 29491 | 40 | ||
| 25644 | 206545 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994446.42204 | 2100465.35227 | 37.747158803252 | -122.461962779858 | (37.747158803252, -122.461962779858) | 1 | 8 | 4 | 29491 | 40 | |||
| 25861 | 206613 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.7468124923186 | -122.459952623323 | (37.7468124923186, -122.459952623323) | 1 | 8 | 4 | 29491 | 40 | |||
| 27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
| 27614 | 65799 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.7467507369343 | -122.473717291816 | (37.7467507369343, -122.473717291816) | 1 | 8 | 4 | 29491 | 40 | ||
| 28113 | 206685 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.456081163331 | (37.734938180348, -122.456081163331) | 9 | 7 | 4 | 59 | 40 | |||
| 28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 28527 | 206648 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.461760191398 | (37.748320765087, -122.461760191398) | 1 | 8 | 4 | 29491 | 40 | |||
| 31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 1 | 8 | 4 | 29491 | 40 | |||
| 32203 | 206500 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993474.54652 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | 1 | 8 | 4 | 56 | 12 | |||
| 32620 | 31228 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.7385237494811 | -122.47111005511 | (37.7385237494811, -122.47111005511) | 1 | 8 | 4 | 29491 | 40 |
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) );