trees
1,914 rows where qSpecies_id = 45 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97709 | 200156 | DPW Maintained 1 | :: 45 | 1047 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | 10 | 3 | 8 | 58 | 1 | |||
| 157514 | 200157 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.392260301004 | (37.7195686584119, -122.392260301004) | 10 | 3 | 8 | 58 | 1 | |||
| 50825 | 200155 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.7196076106807 | -122.392358707449 | (37.7196076106807, -122.392358707449) | 10 | 3 | 8 | 58 | 1 | |||
| 26314 | 200498 | DPW Maintained 1 | :: 45 | 1055 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | 10 | 3 | 8 | 58 | 1 | |||
| 57332 | 104890 | Undocumented 4 | :: 45 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | empty | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||
| 8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
| 66506 | 200248 | DPW Maintained 1 | :: 45 | 1107 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.7197997141545 | -122.392672078819 | (37.7197997141545, -122.392672078819) | 10 | 3 | 8 | 58 | 1 | |||
| 191663 | 200246 | DPW Maintained 1 | :: 45 | 1071 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | 10 | 3 | 8 | 58 | 1 | |||
| 28805 | 200245 | DPW Maintained 1 | :: 45 | 1075 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.7198415597531 | -122.394424294358 | (37.7198415597531, -122.394424294358) | 10 | 3 | 8 | 58 | 1 | |||
| 115629 | 200244 | DPW Maintained 1 | :: 45 | 1123 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.392956785762 | (37.7199591140845, -122.392956785762) | 10 | 3 | 8 | 58 | 1 | |||
| 128848 | 200239 | DPW Maintained 1 | :: 45 | 1131 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.393114655414 | (37.7200560674381, -122.393114655414) | 10 | 3 | 8 | 58 | 1 | |||
| 101961 | 200202 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013720.7054 | 2090215.6197 | 37.72010595277 | -122.394595711042 | (37.72010595277, -122.394595711042) | 10 | 3 | 8 | 58 | 1 | |||
| 155612 | 200201 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013694.5474 | 2090234.3998 | 37.7201560648851 | -122.394687445541 | (37.7201560648851, -122.394687445541) | 10 | 3 | 8 | 58 | 1 | |||
| 71785 | 200213 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013590.5861 | 2090251.1677 | 37.7201963256026 | -122.395047981349 | (37.7201963256026, -122.395047981349) | 10 | 3 | 8 | 58 | 1 | |||
| 76602 | 200226 | DPW Maintained 1 | :: 45 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.7201977688326 | -122.390127728915 | (37.7201977688326, -122.390127728915) | 10 | 3 | 8 | 58 | 1 | |||
| 86077 | 200212 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013545.648 | 2090276.655 | 37.7202638095936 | -122.395205102903 | (37.7202638095936, -122.395205102903) | 10 | 3 | 8 | 58 | 1 | |||
| 191838 | 200182 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013359.1884 | 2090422.8715 | 37.7206549194654 | -122.395859877099 | (37.7206549194654, -122.395859877099) | 10 | 3 | 8 | 58 | 1 | |||
| 145711 | 200183 | DPW Maintained 1 | :: 45 | 1197 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013828.6909 | 2090422.2008 | 37.7206791862384 | -122.394236894514 | (37.7206791862384, -122.394236894514) | 10 | 3 | 8 | 58 | 1 | |||
| 66935 | 200181 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013299.4945 | 2090456.4074 | 37.7207436812319 | -122.396068570714 | (37.7207436812319, -122.396068570714) | 10 | 3 | 8 | 58 | 1 | |||
| 152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
| 174987 | 109571 | Permitted Site 7 | :: 45 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003029.6 | 2091527.8 | 37.7231087370031 | -122.431644859747 | (37.7231087370031, -122.431644859747) | 9 | 7 | 6 | 28861 | 5 | |||
| 144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 49143 | 108801 | Undocumented 4 | :: 45 | 501-599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 151586 | 108799 | Undocumented 4 | :: 45 | 501-599 University St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 169454 | 108800 | Undocumented 4 | :: 45 | 501-599 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 176269 | 108798 | Undocumented 4 | :: 45 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 190627 | 108795 | Undocumented 4 | :: 45 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 6014 | 38201 | Permitted Site 7 | :: 45 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.7234368466837 | -122.405053190481 | (37.7234368466837, -122.405053190481) | 10 | 3 | 7 | 309 | 28 | ||
| 127369 | 200507 | DPW Maintained 1 | :: 45 | 1510 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014614.4494 | 2091644.4715 | 37.724078943993 | -122.391606161162 | (37.724078943993, -122.391606161162) | 10 | 3 | 8 | 58 | 1 | |||
| 52228 | 45785 | Permitted Site 7 | :: 45 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | 9 | 7 | 4 | 28861 | 40 | |||
| 156876 | 45784 | Permitted Site 7 | :: 45 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | 9 | 7 | 4 | 28861 | 40 | ||
| 301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 11763 | 108805 | Undocumented 4 | :: 45 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 15900 | 108806 | Undocumented 4 | :: 45 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 54539 | 108802 | Undocumented 4 | :: 45 | 401-499 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 114694 | 108807 | Undocumented 4 | :: 45 | 401-499 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 121161 | 108804 | Undocumented 4 | :: 45 | 401-499 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
| 35874 | 200502 | DPW Maintained 1 | :: 45 | 1500 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014797.5113 | 2092210.0981 | 37.7256422016088 | -122.391012853891 | (37.7256422016088, -122.391012853891) | 10 | 3 | 8 | 58 | 1 | |||
| 119892 | 200501 | DPW Maintained 1 | :: 45 | 1550 Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014687.5837 | 2092287.487 | 37.7258485955534 | -122.391398275474 | (37.7258485955534, -122.391398275474) | 10 | 3 | 8 | 58 | 1 | |||
| 392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 11776 | 108812 | Undocumented 4 | :: 45 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 45721 | 108810 | Undocumented 4 | :: 45 | 301-399 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 152288 | 108813 | Undocumented 4 | :: 45 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
| 42415 | 108792 | Permitted Site 7 | :: 45 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 61663 | 108793 | Permitted Site 7 | :: 45 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
| 18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
| 60026 | 40070 | Permitted Site 7 | :: 45 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | 10 | 3 | 8 | 58 | 1 | ||
| 1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
| 127804 | 109831 | DPW Maintained 1 | :: 45 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | 9 | 7 | 4 | 28861 | 40 | ||||
| 91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 148781 | 46634 | Permitted Site 7 | :: 45 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.1858404 | 2093576.72961431 | 37.7293914610682 | -122.391309972305 | (37.7293914610682, -122.391309972305) | 10 | 3 | 8 | 58 | 1 | ||
| 38005 | 35482 | Permitted Site 7 | :: 45 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | 9 | 3 | 7 | 309 | 28 | ||
| 115260 | 200762 | DPW Maintained 1 | :: 45 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.391692072282 | (37.7298635995705, -122.391692072282) | 10 | 3 | 8 | 58 | 1 | |||
| 22783 | 200577 | DPW Maintained 1 | :: 45 | 1701 Keith St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015592.5071 | 2093926.7262 | 37.7303998031535 | -122.388384353362 | (37.7303998031535, -122.388384353362) | 10 | 3 | 8 | 58 | 1 | |||
| 33016 | 31148 | Permitted Site 7 | :: 45 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.7307613077995 | -122.44892931603 | (37.7307613077995, -122.44892931603) | 9 | 7 | 4 | 59 | 40 | ||
| 99942 | 31149 | Permitted Site 7 | :: 45 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.7307613077995 | -122.44892931603 | (37.7307613077995, -122.44892931603) | 9 | 7 | 4 | 59 | 40 | ||
| 19220 | 122819 | Undocumented 4 | :: 45 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003309 | 2094407 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | 9 | 7 | 5 | 28861 | 25 | ||||
| 75994 | 46322 | Permitted Site 7 | :: 45 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.7314281831927 | -122.480829241755 | (37.7314281831927, -122.480829241755) | 1 | 8 | 4 | 64 | 35 | |||
| 96682 | 115070 | Significant Tree 6 | :: 45 | 401 DARIEN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5992724 | 2094938 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | 9 | 8 | 4 | 59 | 40 | ||||
| 87438 | 219181 | DPW Maintained 1 | :: 45 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5999211.06214 | 2094946.25439 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | 9 | 7 | 4 | 59 | 40 | |||
| 99412 | 200808 | DPW Maintained 1 | :: 45 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.7324897642599 | -122.386800296411 | (37.7324897642599, -122.386800296411) | 10 | 3 | 8 | 58 | 1 | |||
| 180694 | 200626 | DPW Maintained 1 | :: 45 | 1370 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016343.0854 | 2094895.2737 | 37.7331008048792 | -122.385856958672 | (37.7331008048792, -122.385856958672) | 10 | 3 | 8 | 58 | 1 | |||
| 94232 | 200742 | DPW Maintained 1 | :: 45 | 1454 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.7331467841736 | -122.387617287866 | (37.7331467841736, -122.387617287866) | 10 | 3 | 8 | 58 | 1 | |||
| 29145 | 121591 | Undocumented 4 | :: 45 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000339 | 2095263 | 37.7332118579221 | -122.441213569672 | (37.7332118579221, -122.441213569672) | 9 | 7 | 5 | 63 | 40 | ||||
| 62362 | 200730 | DPW Maintained 1 | :: 45 | 1466 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.73326392707 | -122.387841787924 | (37.73326392707, -122.387841787924) | 10 | 3 | 8 | 58 | 1 | |||
| 190604 | 200729 | DPW Maintained 1 | :: 45 | 1481 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6015678.7414 | 2094969.3688 | 37.7332674687178 | -122.388158962258 | (37.7332674687178, -122.388158962258) | 10 | 3 | 8 | 58 | 1 | |||
| 123816 | 200722 | DPW Maintained 1 | :: 45 | 1476 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | 10 | 3 | 8 | 58 | 1 | |||
| 57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
| 244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
| 170471 | 185122 | DPW Maintained 1 | :: 45 | 2850 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985897.3509 | 2095993.4067 | 37.734384144878 | -122.491195311953 | (37.734384144878, -122.491195311953) | 1 | 8 | 3 | 64 | 35 | |||
| 116283 | 186926 | DPW Maintained 1 | :: 45 | 2800 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985157.2666 | 2096011.7096 | 37.734391129301 | -122.493755335707 | (37.734391129301, -122.493755335707) | 1 | 8 | 3 | 29491 | 35 | |||
| 64951 | 185071 | DPW Maintained 1 | :: 45 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.494363610719 | (37.7344437114318, -122.494363610719) | 1 | 8 | 3 | 29491 | 35 | |||
| 27528 | 185072 | DPW Maintained 1 | :: 45 | 2801 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985073.9331 | 2096042.9736 | 37.7344720961827 | -122.494045746017 | (37.7344720961827, -122.494045746017) | 1 | 8 | 3 | 29491 | 35 | |||
| 45738 | 109978 | Undocumented 4 | :: 45 | 75 Escondido Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986097 | 2096084.1 | 37.73464482809 | -122.490511739576 | (37.73464482809, -122.490511739576) | 1 | 8 | 3 | 64 | 35 | ||||
| 28186 | 185060 | DPW Maintained 1 | :: 45 | 10x El Mirasol Pl | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | 1 | 8 | 3 | 64 | 35 | |||
| 98467 | 200699 | DPW Maintained 1 | :: 45 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.7346588632003 | -122.387564854217 | (37.7346588632003, -122.387564854217) | 10 | 3 | 8 | 58 | 1 | |||
| 10340 | 36516 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | 2 | 7 | 7 | 28859 | 2 | ||
| 18354 | 36517 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | 2 | 7 | 7 | 28859 | 2 | ||
| 74348 | 36518 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | 2 | 7 | 7 | 28859 | 2 | ||
| 158754 | 36519 | Permitted Site 7 | :: 45 | 430 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | 2 | 7 | 7 | 28859 | 2 | ||
| 144795 | 256696 | Permitted Site 7 | :: 45 | 42 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6001984.33449 | 2095868.04808 | 37.7349667666113 | -122.435568480167 | (37.7349667666113, -122.435568480167) | 2 | 7 | 5 | 63 | 7 | |||
| 170424 | 45263 | Permitted Site 7 | :: 45 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | 2 | 7 | 7 | 28859 | 2 | ||
| 156298 | 184973 | DPW Maintained 1 | :: 45 | 2701 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985060.7433 | 2096318.9125 | 37.7352289790934 | -122.494111677716 | (37.7352289790934, -122.494111677716) | 1 | 8 | 3 | 29491 | 35 | |||
| 7167 | 120669 | Undocumented 4 | :: 45 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974 | 2096001 | 37.7352743855737 | -122.439071080789 | (37.7352743855737, -122.439071080789) | 2 | 7 | 5 | 63 | 7 | ||
| 61312 | 245370 | DPW Maintained 1 | :: 45 | 3943 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005173.0525 | 2095986.393 | 37.7354723102432 | -122.424552361242 | (37.7354723102432, -122.424552361242) | 2 | 7 | 7 | 28859 | 2 | |||
| 64495 | 185049 | DPW Maintained 1 | :: 45 | 2731 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983672.3577 | 2096556.9514 | 37.7358012305935 | -122.49892933939 | (37.7358012305935, -122.49892933939) | 1 | 8 | 3 | 29491 | 35 | |||
| 190716 | 184974 | DPW Maintained 1 | :: 45 | 2700 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984964.6462 | 2096531.6242 | 37.735807405046 | -122.494459590864 | (37.735807405046, -122.494459590864) | 1 | 8 | 3 | 29491 | 35 | |||
| 35508 | 3826 | DPW Maintained 1 | :: 45 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | 10 | 3 | 8 | 58 | 1 | ||
| 113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
| 29284 | 36507 | Permitted Site 7 | :: 45 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.7361990307601 | -122.415517981354 | (37.7361990307601, -122.415517981354) | 2 | 7 | 7 | 28859 | 2 | ||
| 120288 | 182946 | DPW Maintained 1 | :: 45 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | 1 | 8 | 3 | 29491 | 35 | |||
| 276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
| 19158 | 121128 | Undocumented 4 | :: 45 | 201 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 35157 | 121129 | Undocumented 4 | :: 45 | 201 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 103132 | 121127 | Undocumented 4 | :: 45 | 201 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 159013 | 121130 | Undocumented 4 | :: 45 | 201 Bemis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||||
| 193377 | 121126 | Undocumented 4 | :: 45 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 49932 | 182944 | DPW Maintained 1 | :: 45 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.505248885687 | (37.7365450979685, -122.505248885687) | 1 | 8 | 3 | 29491 | 35 | |||
| 20028 | 182943 | DPW Maintained 1 | :: 45 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | 1 | 8 | 3 | 29491 | 35 | |||
| 49042 | 182938 | DPW Maintained 1 | :: 45 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | 1 | 8 | 3 | 29491 | 35 |
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) );