trees
310 rows where Police Districts = 7 and qSpecies_id = 65 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47768 | 221885 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008227.02437 | 2099369.61702 | 37.7449338966774 | -122.414232888254 | (37.7449338966774, -122.414232888254) | 2 | 7 | 7 | 28859 | 2 | |||
| 121889 | 221935 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6004836.87593 | 2097581.93653 | 37.7398343216046 | -122.425828185523 | (37.7398343216046, -122.425828185523) | 2 | 7 | 5 | 63 | 7 | |||
| 13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
| 730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
| 19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
| 48996 | 94666 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020 | 2095225 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | 9 | 7 | 5 | 28861 | 25 | |
| 152880 | 221838 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004035.03303 | 2095100.17103 | 37.7329746104714 | -122.42842377735 | (37.7329746104714, -122.42842377735) | 9 | 7 | 5 | 28861 | 25 | |||
| 93692 | 221803 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005068.88763 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | 2 | 7 | 5 | 63 | 22 | |||
| 165722 | 64259 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.424779179687 | (37.7430780980429, -122.424779179687) | 2 | 7 | 5 | 63 | 22 | ||
| 53331 | 203580 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | 9 | 7 | 4 | 63 | 40 | |||
| 78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
| 55051 | 67285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.7263559262182 | -122.425894675863 | (37.7263559262182, -122.425894675863) | 9 | 7 | 6 | 28861 | 5 | ||
| 62808 | 67908 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.7283565792877 | -122.44478069728 | (37.7283565792877, -122.44478069728) | 9 | 7 | 4 | 28861 | 40 | ||
| 172281 | 203590 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.7283460957772 | -122.444892431558 | (37.7283460957772, -122.444892431558) | 9 | 7 | 4 | 28861 | 40 | |||
| 154673 | 221886 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 121 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006322.71195 | 2097511.22057 | 37.7397240062552 | -122.420685761336 | (37.7397240062552, -122.420685761336) | 2 | 7 | 7 | 28859 | 2 | |||
| 37651 | 64302 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25113 | 6005123.1483335 | 2099287.66798911 | 37.7445340460317 | -122.42495970266 | (37.7445340460317, -122.42495970266) | 2 | 7 | 5 | 63 | 22 | ||
| 186207 | 114881 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
| 76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
| 176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 63 | 40 | ||
| 129007 | 221787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 6005680.59891 | 2100245.58826 | 37.7471957491868 | -122.423100223394 | (37.7471957491868, -122.423100223394) | 2 | 7 | 5 | 28859 | 22 | |||
| 80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
| 22865 | 66317 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211357 | 37.732303560745 | -122.438056328119 | (37.732303560745, -122.438056328119) | 9 | 7 | 4 | 63 | 40 | ||
| 67978 | 67941 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.7346682618025 | -122.427968106929 | (37.7346682618025, -122.427968106929) | 2 | 7 | 5 | 28861 | 25 | ||
| 71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
| 32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
| 60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
| 7022 | 70397 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6006350.25387 | 2093285.00079 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | 9 | 7 | 7 | 309 | 5 | |||
| 11272 | 221805 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003874.14486 | 2100377.76702 | 37.7474565750744 | -122.429356224108 | (37.7474565750744, -122.429356224108) | 2 | 7 | 5 | 63 | 22 | |||
| 115143 | 221806 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.7474184051535 | -122.429351626769 | (37.7474184051535, -122.429351626769) | 2 | 7 | 5 | 63 | 22 | |||
| 95508 | 115201 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
| 135492 | 115202 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
| 141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
| 8616 | 47055 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | ||
| 91379 | 47054 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | |||
| 102836 | 203534 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995350.02472 | 2096965.99603 | 37.7376024192215 | -122.45858493525 | (37.7376024192215, -122.45858493525) | 9 | 7 | 4 | 59 | 40 | |||
| 150799 | 203533 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995336.83178 | 2096965.96659 | 37.737601580145 | -122.458630547087 | (37.737601580145, -122.458630547087) | 9 | 7 | 4 | 59 | 40 | |||
| 76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
| 156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
| 3753 | 64301 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.6099578 | 2099277.06478887 | 37.7444941674798 | -122.425617791869 | (37.7444941674798, -122.425617791869) | 2 | 7 | 5 | 63 | 22 | ||
| 126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
| 110481 | 175078 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001809.64472 | 2092991.82578 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | 9 | 7 | 6 | 28861 | 25 | |||
| 72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
| 128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
| 190685 | 39931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.70332 | 2087956.69983 | 37.7137123004597 | -122.406282682604 | (37.7137123004597, -122.406282682604) | 9 | 7 | 8 | 309 | 39 | |
| 72103 | 40424 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.455589722394 | (37.7310042675093, -122.455589722394) | 9 | 7 | 4 | 28861 | 40 | |
| 183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 | ||
| 32667 | 221878 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 18 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006985.0649 | 2099647.22119 | 37.7456262946341 | -122.41854704763 | (37.7456262946341, -122.41854704763) | 2 | 7 | 7 | 28859 | 2 | |||
| 83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
| 67282 | 203548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999484.36005 | 2094058.99303 | 37.7298572167403 | -122.444081798854 | (37.7298572167403, -122.444081798854) | 9 | 7 | 4 | 63 | 40 | |||
| 117173 | 203550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999525.01063 | 2094056.66117 | 37.7298531329131 | -122.443941098101 | (37.7298531329131, -122.443941098101) | 9 | 7 | 4 | 63 | 40 | |||
| 138666 | 203551 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5999536.14329 | 2094057.1534 | 37.7298551194964 | -122.443902646692 | (37.7298551194964, -122.443902646692) | 9 | 7 | 4 | 63 | 40 | |||
| 142087 | 203547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5999467.73526 | 2094058.60837 | 37.7298552121426 | -122.444139244847 | (37.7298552121426, -122.444139244847) | 9 | 7 | 4 | 63 | 40 | |||
| 165676 | 203552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999546.8407 | 2094056.93019 | 37.7298551168086 | -122.443865648605 | (37.7298551168086, -122.443865648605) | 9 | 7 | 4 | 63 | 40 | |||
| 169633 | 203549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999506.56732 | 2094057.55855 | 37.7298545448296 | -122.444004922987 | (37.7298545448296, -122.444004922987) | 9 | 7 | 4 | 63 | 40 | |||
| 98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
| 176854 | 67934 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 31647 | 6003947.82619719 | 2095984.77824106 | 37.7353986067624 | -122.428788314932 | (37.7353986067624, -122.428788314932) | 2 | 7 | 5 | 63 | 7 | ||
| 22793 | 221849 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004448.4556 | 2095570.1665 | 37.7342884984186 | -122.427027930603 | (37.7342884984186, -122.427027930603) | 2 | 7 | 5 | 28861 | 25 | |||
| 29348 | 221851 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004484.38042 | 2095546.73676 | 37.7342261969882 | -122.426902058798 | (37.7342261969882, -122.426902058798) | 2 | 7 | 5 | 28861 | 25 | |||
| 38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
| 95747 | 221850 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004464.56621 | 2095558.73638 | 37.7342580248697 | -122.426971417216 | (37.7342580248697, -122.426971417216) | 2 | 7 | 5 | 28861 | 25 | |||
| 140076 | 221903 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004552.30027 | 2095513.5436 | 37.7341388961924 | -122.426664875203 | (37.7341388961924, -122.426664875203) | 2 | 7 | 5 | 28861 | 25 | |||
| 166822 | 221848 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004429.19741 | 2095585.11426 | 37.7343284525969 | -122.427095576708 | (37.7343284525969, -122.427095576708) | 2 | 7 | 5 | 28861 | 25 | |||
| 167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
| 192333 | 221847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004411.28278 | 2095593.12873 | 37.7343494454616 | -122.427158084072 | (37.7343494454616, -122.427158084072) | 2 | 7 | 5 | 28861 | 25 | |||
| 69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
| 23185 | 241540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004426.52656 | 2097222.39048 | 37.7388238918993 | -122.427221397276 | (37.7388238918993, -122.427221397276) | 2 | 7 | 5 | 63 | 7 | |
| 164548 | 175191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 193 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010202.71269 | 2087988.02388 | 37.7137932196449 | -122.406599386967 | (37.7137932196449, -122.406599386967) | 9 | 7 | 8 | 309 | 39 | |||
| 578 | 221823 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.415618808282 | (37.7360633428545, -122.415618808282) | 2 | 7 | 7 | 28859 | 2 | |||
| 10220 | 221824 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007730.82531 | 2096150.27006 | 37.7360663969372 | -122.415720751814 | (37.7360663969372, -122.415720751814) | 2 | 7 | 7 | 28859 | 2 | |||
| 20115 | 97549 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
| 23012 | 97550 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
| 145681 | 97551 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||||
| 7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
| 18580 | 262400 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
| 185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | ||
| 121688 | 4845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589432 | (37.7395500270059, -122.41939589432) | 2 | 7 | 7 | 28859 | 2 | ||
| 169503 | 65718 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.440565289581 | (37.7124240746766, -122.440565289581) | 9 | 7 | 6 | 28861 | 5 | |
| 93237 | 203567 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | 9 | 7 | 4 | 28861 | 40 | |||
| 159587 | 203566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5996063.41122 | 2094232.89601 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | 9 | 7 | 4 | 28861 | 40 | |||
| 35544 | 221939 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 21 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.430782023672 | (37.740283068906, -122.430782023672) | 2 | 7 | 5 | 63 | 7 | |||
| 154695 | 4846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 210 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 15 | 3X3 | 6006713.9746 | 2097429.76412 | 37.7395223890352 | -122.419327161814 | (37.7395223890352, -122.419327161814) | 2 | 7 | 7 | 28859 | 2 | ||
| 169336 | 221863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003563.65489 | 2095975.96127 | 37.7353526463955 | -122.430115909332 | (37.7353526463955, -122.430115909332) | 2 | 7 | 5 | 63 | 7 | |||
| 146650 | 170415 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 216 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779296 | 6001929.08412 | 2093967.91374 | 37.7297462952572 | -122.435623604862 | (37.7297462952572, -122.435623604862) | 9 | 7 | 6 | 28861 | 25 | |
| 171966 | 64298 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 217 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25107 | 6005164.15015163 | 2098998.20846843 | 37.7437415721643 | -122.424797337889 | (37.7437415721643, -122.424797337889) | 2 | 7 | 5 | 63 | 22 | ||
| 4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
| 153032 | 243747 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004399.27823 | 2097187.62567 | 37.7387268946327 | -122.427313133507 | (37.7387268946327, -122.427313133507) | 2 | 7 | 5 | 63 | 7 | |
| 105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
| 65100 | 221877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.7455296507747 | -122.418615385312 | (37.7455296507747, -122.418615385312) | 2 | 7 | 7 | 28859 | 2 | |||
| 94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
| 86106 | 66313 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.435659572604 | (37.7324561325978, -122.435659572604) | 9 | 7 | 5 | 63 | 40 | ||
| 105355 | 203573 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001918.41123 | 2094952.28541 | 37.7324485484508 | -122.435730902059 | (37.7324485484508, -122.435730902059) | 9 | 7 | 5 | 63 | 40 | |||
| 21507 | 62444 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25105 | 6005138.76094737 | 2098996.79373606 | 37.7437362535856 | -122.424885027142 | (37.7437362535856, -122.424885027142) | 2 | 7 | 5 | 63 | 22 | ||
| 38682 | 158242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003158.9626 | 2096376.80466 | 37.7364303417798 | -122.431543687401 | (37.7364303417798, -122.431543687401) | 2 | 7 | 5 | 63 | 7 |
| 63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
| 117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
| 180750 | 158239 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780004 | 6003126.50979 | 2096349.74034 | 37.7363541898933 | -122.43165395869 | (37.7363541898933, -122.43165395869) | 2 | 7 | 5 | 63 | 7 |
| 69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
| 158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
| 100205 | 221884 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | 2 | 7 | 7 | 28859 | 2 | |||
| 95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 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) );