trees
493 rows where qSpecies_id = 133 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137454 | 45121 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 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 | ||
| 172217 | 45117 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 1435 | 68125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.7444006509706 | -122.421806351312 | (37.7444006509706, -122.421806351312) | 2 | 7 | 5 | 28859 | 2 | ||
| 4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 28859 | 2 | |||
| 5637 | 223045 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.7451501107949 | -122.413843827126 | (37.7451501107949, -122.413843827126) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 18410 | 68121 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.7451912827439 | -122.421094842871 | (37.7451912827439, -122.421094842871) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 20331 | 95111 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.7278683408513 | -122.436360947301 | (37.7278683408513, -122.436360947301) | 9 | 7 | 6 | 28861 | 25 |
| 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 | ||
| 22790 | 63803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.410751365299 | (37.7385764323817, -122.410751365299) | 10 | 7 | 7 | 28859 | 2 | ||
| 26466 | 34431 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38175 | 6002613.57489862 | 2096408.07550267 | 37.7364852770817 | -122.433431554421 | (37.7364852770817, -122.433431554421) | 2 | 7 | 5 | 63 | 7 | ||
| 26895 | 24597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.416856984981 | (37.7391518611665, -122.416856984981) | 2 | 7 | 7 | 28859 | 2 | ||
| 27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
| 27571 | 69506 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.411531974789 | (37.7369238689745, -122.411531974789) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | ||||
| 32898 | 51448 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | 2 | 7 | 7 | 28859 | 2 | |||
| 34836 | 58683 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | 2 | 7 | 7 | 28859 | 2 | ||
| 36175 | 68120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.7453405673201 | -122.421200665955 | (37.7453405673201, -122.421200665955) | 2 | 7 | 5 | 28859 | 2 | ||
| 37816 | 62939 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.419076042669 | (37.7386903299864, -122.419076042669) | 2 | 7 | 7 | 28859 | 2 | ||
| 40567 | 206697 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998934.95382 | 2095541.69667 | 37.7338970145182 | -122.446087759167 | (37.7338970145182, -122.446087759167) | 9 | 7 | 4 | 59 | 40 | |||
| 42650 | 68124 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31872 | 6006189.84017158 | 2099400.84484915 | 37.7449049995041 | -122.421279326768 | (37.7449049995041, -122.421279326768) | 2 | 7 | 7 | 28859 | 2 | ||
| 44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
| 45262 | 94075 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | 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 | ||
| 47735 | 206689 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.455762520949 | (37.734869823774, -122.455762520949) | 9 | 7 | 4 | 59 | 40 | |||
| 47801 | 206671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.458746484089 | (37.732762033223, -122.458746484089) | 9 | 7 | 4 | 59 | 40 | |||
| 48275 | 41698 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
| 48817 | 41708 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.435194188204 | (37.7355450223799, -122.435194188204) | 2 | 7 | 5 | 63 | 7 | ||
| 49032 | 206680 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995948.68471 | 2096013.62894 | 37.7350218397753 | -122.456446248507 | (37.7350218397753, -122.456446248507) | 9 | 7 | 4 | 59 | 40 | |||
| 52704 | 94078 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 4 | 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 | ||
| 54361 | 62908 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.417497229597 | (37.7390843209207, -122.417497229597) | 2 | 7 | 7 | 28859 | 2 | ||
| 54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
| 57524 | 47492 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.436445238065 | (37.7277113821718, -122.436445238065) | 9 | 7 | 6 | 28861 | 25 | |
| 62246 | 121661 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 63437 | 60436 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 474 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.7435369501722 | -122.430530149996 | (37.7435369501722, -122.430530149996) | 2 | 7 | 5 | 63 | 22 | ||
| 66516 | 53193 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.7459214666672 | -122.419059278748 | (37.7459214666672, -122.419059278748) | 2 | 7 | 7 | 28859 | 2 | ||
| 66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
| 68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
| 72421 | 206678 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995925.9256 | 2096013.73306 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | 9 | 7 | 4 | 59 | 40 | |||
| 72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
| 76261 | 26484 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 154 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000987.64369 | 2098692.25572 | 37.7426647191989 | -122.439216742684 | (37.7426647191989, -122.439216742684) | 2 | 7 | 5 | 63 | 7 | |||
| 76572 | 223055 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | 2 | 7 | 5 | 63 | 7 | |||
| 79608 | 206693 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.7406100866944 | -122.45017375512 | (37.7406100866944, -122.45017375512) | 9 | 7 | 4 | 59 | 40 | |||
| 80109 | 206672 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995263.98331 | 2095214.43939 | 37.732788127969 | -122.458755649049 | (37.732788127969, -122.458755649049) | 9 | 7 | 4 | 59 | 40 | |||
| 80974 | 62145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.423928154749 | (37.7454017512266, -122.423928154749) | 2 | 7 | 5 | 28859 | 22 | ||
| 85025 | 48468 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.7464863595987 | -122.431306366847 | (37.7464863595987, -122.431306366847) | 2 | 7 | 5 | 63 | 22 | ||
| 86127 | 32398 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.59209 | 37.7358062077876 | -122.421800215602 | (37.7358062077876, -122.421800215602) | 2 | 7 | 7 | 28859 | 2 | |
| 86717 | 206692 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996416.06092 | 2095880.87144 | 37.7346841407625 | -122.454820783252 | (37.7346841407625, -122.454820783252) | 9 | 7 | 4 | 59 | 40 | |||
| 86826 | 121662 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
| 87329 | 206675 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995199.65146 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | 9 | 7 | 4 | 59 | 40 | |||
| 87754 | 43489 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.7344536647683 | -122.413002801242 | (37.7344536647683, -122.413002801242) | 10 | 7 | 7 | 28859 | 2 | ||
| 89950 | 63825 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.7386885782033 | -122.411368915099 | (37.7386885782033, -122.411368915099) | 10 | 7 | 7 | 28859 | 2 | ||
| 92618 | 223022 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006257.51967 | 2099541.04409 | 37.7452937702941 | -122.42105525589 | (37.7452937702941, -122.42105525589) | 2 | 7 | 7 | 28859 | 2 | |||
| 92777 | 247816 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.7418392269952 | -122.432127661269 | (37.7418392269952, -122.432127661269) | 2 | 7 | 5 | 63 | 22 | |||
| 96900 | 62944 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.7385700935458 | -122.41866583942 | (37.7385700935458, -122.41866583942) | 2 | 7 | 7 | 28859 | 2 | ||
| 96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
| 97367 | 206691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996439.41867 | 2095873.69496 | 37.7346657757093 | -122.454739509716 | (37.7346657757093, -122.454739509716) | 9 | 7 | 4 | 59 | 40 | |||
| 97453 | 206694 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811219 | (37.733607556928, -122.43675811219) | 9 | 7 | 5 | 63 | 40 | |||
| 99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
| 99489 | 68122 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31870 | 6006226.82006776 | 2099469.59440232 | 37.7450958550009 | -122.42115633768 | (37.7450958550009, -122.42115633768) | 2 | 7 | 7 | 28859 | 2 | ||
| 101316 | 94077 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | 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 | ||
| 101641 | 35101 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | 9 | 7 | 6 | 28861 | 5 | ||
| 101700 | 247588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6 | 6008943.01163 | 2096440.06729 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | 10 | 7 | 7 | 28859 | 2 | ||||
| 108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
| 110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
| 111443 | 62943 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | 2 | 7 | 7 | 28859 | 2 | ||
| 111603 | 62913 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | 2 | 7 | 7 | 28859 | 2 | ||
| 111864 | 206687 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996087.44674 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | 9 | 7 | 4 | 59 | 40 | |||
| 112602 | 63806 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.410835957293 | (37.7396522194543, -122.410835957293) | 10 | 7 | 7 | 28859 | 2 | ||
| 114823 | 223042 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.7363546053902 | -122.418528488295 | (37.7363546053902, -122.418528488295) | 2 | 7 | 7 | 28859 | 2 | |||
| 115399 | 61289 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | 2 | 7 | 7 | 28859 | 2 | ||
| 116102 | 223039 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007708.38718 | 2096815.60919 | 37.7378920108046 | -122.415845428432 | (37.7378920108046, -122.415845428432) | 2 | 7 | 7 | 28859 | 2 | |||
| 116769 | 24553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.417556712385 | (37.7390994163072, -122.417556712385) | 2 | 7 | 7 | 28859 | 2 | |||
| 118553 | 206677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.460051576629 | (37.7347770452256, -122.460051576629) | 9 | 7 | 4 | 59 | 40 | |||
| 122610 | 176075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001444.80034 | 2093622.381 | 37.7287700227166 | -122.4372730928 | (37.7287700227166, -122.4372730928) | 9 | 7 | 6 | 28861 | 25 | |||
| 123118 | 67138 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | 2 | 7 | 7 | 28859 | 2 | ||
| 123767 | 223041 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 408 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 776709 | 6007256.61829 | 2097259.39898 | 37.7390851512711 | -122.417438860719 | (37.7390851512711, -122.417438860719) | 2 | 7 | 7 | 28859 | 2 | ||
| 124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
| 126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 40 | |||
| 126227 | 206696 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000774.6257 | 2094855.98841 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | 9 | 7 | 4 | 63 | 40 | |||
| 126962 | 62916 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.7379096064175 | -122.415800456905 | (37.7379096064175, -122.415800456905) | 2 | 7 | 7 | 28859 | 2 | ||
| 127288 | 206690 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245 | (37.7348932897948, -122.45581025245) | 9 | 7 | 4 | 59 | 40 | |||
| 128090 | 65685 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 265 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28609 | 5995018.52111157 | 2095862.640949 | 37.7345538192853 | -122.459651200361 | (37.7345538192853, -122.459651200361) | 9 | 7 | 4 | 59 | 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) );