trees
8,758 rows where qSpecies_id = 16 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18077 | 262510 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
18187 | 35206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18230 | 35204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18875 | 46976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44996 | |||||||||||||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
19027 | 260904 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4228 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5993841 | 2112866 | 37.7811728620679 | -122.464956727678 | (37.7811728620679, -122.464956727678) | 11 | 6 | 2 | 54 | 11 | ||||
19191 | 122767 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
20041 | 97746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
20068 | 59210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 655 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21769 | 6004452.7032449 | 2107745.67004762 | 37.7677198351136 | -122.427880529994 | (37.7677198351136, -122.427880529994) | 8 | 4 | 5 | 28862 | 3 | ||
20158 | 64031 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2328 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24788 | 6002100.67136952 | 2107083.49233192 | 37.7657683190956 | -122.435968519546 | (37.7657683190956, -122.435968519546) | 15 | 5 | 5 | 28862 | 3 | ||
20443 | 94864 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987748.3 | 2115456.9 | 37.7879335515465 | -122.486224435532 | (37.7879335515465, -122.486224435532) | 11 | 6 | 1 | 55 | 33 | |||||
20520 | 66318 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 158 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1994 12:00:00 AM | Permit Number 29435 | 6001030.24418552 | 2094968.77102458 | 37.7324433243511 | -122.438802679239 | (37.7324433243511, -122.438802679239) | 9 | 7 | 5 | 63 | 40 | ||
20648 | 38458 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21073 | 118697 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4445 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5981741.45625 | 2110952.76376 | 37.7752146003791 | -122.506672472372 | (37.7752146003791, -122.506672472372) | 11 | 6 | 2 | 55 | 26 | ||||
21337 | 67795 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4518 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31438 | 6000923.92278491 | 2101155.09439533 | 37.7494234620324 | -122.439613590872 | (37.7494234620324, -122.439613590872) | 2 | 4 | 5 | 28862 | 22 | ||
21521 | 42412 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3x3 | Permit Number 42563 | 5999726.22128483 | 2094340.1247016 | 37.7306429333402 | -122.443265843466 | (37.7306429333402, -122.443265843466) | 9 | 7 | 4 | 63 | 40 | |
21614 | 38755 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 133 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | 6 | 2 | 9 | 28856 | 34 | |||
21659 | 121452 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3309 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006243 | 2103692 | 37.7566905254498 | -122.421400193147 | (37.7566905254498, -122.421400193147) | 2 | 4 | 5 | 28859 | 19 | ||||
21938 | 60941 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1321 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20744 | 5990787.68033218 | 2105162.79852462 | 37.7598454365266 | -122.474957124226 | (37.7598454365266, -122.474957124226) | 1 | 8 | 4 | 56 | 12 | ||
22530 | 53620 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4141 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2005 12:00:00 AM | Permit Number 25609 | 5994220.86460548 | 2112760.64463827 | 37.7809054799633 | -122.463634946142 | (37.7809054799633, -122.463634946142) | 11 | 6 | 2 | 54 | 11 | ||
22705 | 60402 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1983 12:00:00 AM | Permit Number 19983 | 6015531.43578619 | 2094383.98110516 | 37.7316519491055 | -122.38862739374 | (37.7316519491055, -122.38862739374) | 10 | 3 | 8 | 58 | 1 | ||
22854 | 35428 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38876 | 6014234.60360095 | 2101971.010972 | 37.7524123965466 | -122.393641658261 | (37.7524123965466, -122.393641658261) | 10 | 3 | 8 | 28856 | 1 | ||
23111 | 57682 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 76 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23652 | 6007210.05006368 | 2099046.97615759 | 37.7439908199505 | -122.417726543062 | (37.7439908199505, -122.417726543062) | 2 | 7 | 7 | 28859 | 2 | ||
23118 | 104735 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
23141 | 252866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1660 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000023 | 2106990 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | 15 | 5 | 5 | 29492 | 3 | ||||
23289 | 49437 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3@ MISSION Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2003 12:00:00 AM | Permit Number 46375 | 6003548.64225142 | 2094029.15266288 | 37.7300062998348 | -122.430028982099 | (37.7300062998348, -122.430028982099) | 9 | 7 | 6 | 28861 | 5 | |||
23483 | 93742 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1701 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53320 | 5982802.7 | 2103504.9 | 37.7548273283639 | -122.502450103836 | (37.7548273283639, -122.502450103836) | 1 | 8 | 3 | 56 | 35 | ||
23526 | 99814 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 709 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001253 | 2102268 | 37.7524979583971 | -122.438555365412 | (37.7524979583971, -122.438555365412) | 2 | 4 | 5 | 28862 | 22 | ||||
23549 | 38468 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.380809935654 | (37.7264471943371, -122.380809935654) | 10 | 3 | 8 | 58 | 1 | ||
23660 | 111984 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988113 | 2115801 | 37.7888996007164 | -122.484987910575 | (37.7888996007164, -122.484987910575) | 11 | 6 | 1 | 55 | 33 | |||||
23697 | 67745 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31364 | 5994591.15770406 | 2105174.58392635 | 37.7600974841916 | -122.461803707725 | (37.7600974841916, -122.461803707725) | 1 | 5 | 4 | 56 | 12 | ||
23714 | 120955 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2498x 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5985867 | 2098260 | 37.7406058338313 | -122.491467021888 | (37.7406058338313, -122.491467021888) | 1 | 8 | 3 | 29491 | 35 | ||||
23793 | 66834 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4530 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30134 | 6001362.3950228 | 2104101.28182841 | 37.757537930173 | -122.438308386417 | (37.757537930173, -122.438308386417) | 2 | 4 | 5 | 28862 | 3 | ||
23870 | 112180 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 29 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001191.11608658 | 2107799.74836318 | 37.7676832682347 | -122.439165810551 | (37.7676832682347, -122.439165810551) | 15 | 5 | 5 | 29492 | 3 | |||||
24458 | 121068 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600x Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012133 | 2117811 | 37.7957883852557 | -122.402022845886 | (37.7957883852557, -122.402022845886) | 3 | 1 | 10 | 28860 | 4 | ||||
24812 | 69531 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 23 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1997 12:00:00 AM | Permit Number 38565 | 5995300.80915633 | 2090069.63363967 | 37.7186638440628 | -122.458256093312 | (37.7186638440628, -122.458256093312) | 9 | 8 | 6 | 28861 | 24 | ||
24853 | 33450 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37612 | 6006204.48588434 | 2098216.0412716 | 37.7416526217947 | -122.421144571461 | (37.7416526217947, -122.421144571461) | 2 | 7 | 7 | 28859 | 2 | ||
25191 | 46388 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2295 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2002 12:00:00 AM | Permit Number 44622 | 5982642.85284032 | 2099514.23633708 | 37.7438606839213 | -122.50270751461 | (37.7438606839213, -122.50270751461) | 1 | 8 | 3 | 29491 | 35 | |||
25520 | 48608 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601 Laguna Honda Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45913 | 5995627.89976884 | 2099973.91079987 | 37.7458773763018 | -122.457841793887 | (37.7458773763018, -122.457841793887) | 1 | 5 | 4 | 59 | 40 | ||
25716 | 113393 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1157 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991341.204045 | 2105182.26510955 | 37.7599309492843 | -122.473044194983 | (37.7599309492843, -122.473044194983) | 1 | 8 | 4 | 56 | 12 | |||||
25909 | 65174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 387 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27155 | 6003335.1363702 | 2091472.28769894 | 37.7229736263314 | -122.430584722358 | (37.7229736263314, -122.430584722358) | 9 | 7 | 6 | 28861 | 5 | ||
25950 | 43945 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
26253 | 92760 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
26531 | 48504 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 DUNCAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45842 | 6001463 | 2099645 | 37.74530776868 | -122.437641318122 | (37.74530776868, -122.437641318122) | 2 | 7 | 5 | 63 | 22 | |||
26723 | 60948 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1468 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20751 | 5990564.16658645 | 2105397.44668427 | 37.760476762007 | -122.475747276107 | (37.760476762007, -122.475747276107) | 1 | 8 | 4 | 56 | 12 | ||
26744 | 70431 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/14/1994 12:00:00 AM | 5982333 | 2105594 | 37.760535794591 | -122.504229174925 | (37.760535794591, -122.504229174925) | 1 | 8 | 3 | 56 | 35 | ||||
26795 | 122525 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401X 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991964 | 2099053 | 37.7431376164688 | -122.470443874693 | (37.7431376164688, -122.470443874693) | 1 | 8 | 4 | 29491 | 40 | ||||
27202 | 99737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Ocean Ave | 3 | Median : Cutout | Tree | DPW 1 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.451579911331 | (37.7230482703916, -122.451579911331) | 9 | 7 | 4 | 28861 | 40 | |||||
27400 | 61399 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3475 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1984 12:00:00 AM | Permit Number 21320 | 6003740 | 2106504 | 37.7642701648621 | -122.430257086872 | (37.7642701648621, -122.430257086872) | 8 | 4 | 5 | 28862 | 3 | ||
27448 | 60453 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 55 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20039 | 5997304.95350549 | 2089626.85149237 | 37.7175630280021 | -122.451296696164 | (37.7175630280021, -122.451296696164) | 9 | 8 | 6 | 28861 | 24 | ||
27459 | 60485 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1932 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20082 | 6001639.16091534 | 2112906.52803735 | 37.7817306906961 | -122.437981918324 | (37.7817306906961, -122.437981918324) | 15 | 5 | 11 | 29490 | 41 | ||
27477 | 66316 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 109 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29433 | 6001346.41181559 | 2094911.84175155 | 37.7323049921124 | -122.437705539622 | (37.7323049921124, -122.437705539622) | 9 | 7 | 4 | 63 | 40 | ||
27478 | 93935 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 3 | Sidewalk: Curb side : | Tree | Private 2 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | ||
27612 | 97748 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
27734 | 38751 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 133 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | 6 | 2 | 9 | 28856 | 34 | |||
27793 | 173597 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 473 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003668 | 2105532 | 37.7615972080674 | -122.430436757163 | (37.7615972080674, -122.430436757163) | 8 | 4 | 5 | 28862 | 3 | ||||
27851 | 46661 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44793 | 5991818.71549774 | 2105884.90981093 | 37.7618878605445 | -122.471443929487 | (37.7618878605445, -122.471443929487) | 1 | 8 | 4 | 56 | 12 | ||
28150 | 89203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51819 | 5980950.8 | 2106264.9 | 37.7622965064063 | -122.509059305785 | (37.7622965064063, -122.509059305785) | 1 | 8 | 3 | 56 | 35 | ||
28184 | 109638 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1X Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
28519 | 48638 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1248 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45931 | 5993641.01140633 | 2106997.8271038 | 37.7650488907109 | -122.465222217809 | (37.7650488907109, -122.465222217809) | 11 | 8 | 11 | 56 | 12 | ||
28536 | 31687 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 723 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35191 | 5998531.56699721 | 2108118.02123307 | 37.7684054707307 | -122.448387742887 | (37.7684054707307, -122.448387742887) | 15 | 5 | 11 | 29492 | 9 | |||
28582 | 38342 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | Permit Number 40409 | 5982212.43055019 | 2104548.99515309 | 37.757659416739 | -122.504568736791 | (37.757659416739, -122.504568736791) | 1 | 8 | 3 | 56 | 35 | ||
28801 | 63186 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2072 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23725 | 6000958.120646 | 2112814.52536738 | 37.7814393221352 | -122.440331391372 | (37.7814393221352, -122.440331391372) | 15 | 5 | 11 | 29490 | 41 | ||
28835 | 43958 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
28897 | 121325 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 125 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 5987419 | 2115743 | 37.7886999017323 | -122.487384762474 | (37.7886999017323, -122.487384762474) | 11 | 6 | 1 | 55 | 33 | ||||
28912 | 60362 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1367 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19940 | 6016120.25691053 | 2094294.89979422 | 37.7314399645537 | -122.386585493961 | (37.7314399645537, -122.386585493961) | 10 | 3 | 8 | 58 | 1 | ||
29132 | 104609 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
29158 | 63978 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1992 12:00:00 AM | Permit Number 24718 | 6005492.55213554 | 2104572.44995479 | 37.7590656950457 | -122.424058128383 | (37.7590656950457, -122.424058128383) | 2 | 4 | 5 | 28859 | 19 | ||
29203 | 60394 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1490 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19974 | 6015495.25589762 | 2094826.0117953 | 37.7328636713029 | -122.388783323056 | (37.7328636713029, -122.388783323056) | 10 | 3 | 8 | 58 | 1 | ||
29205 | 54207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 525 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9945 | 5994167.427381 | 2106639.11364061 | 37.7640943000648 | -122.463375455955 | (37.7640943000648, -122.463375455955) | 1 | 5 | 11 | 56 | 12 | |||
29317 | 92765 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
29327 | 65347 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 519 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28180 | 6003450.33093159 | 2095958.48681106 | 37.7352982464866 | -122.430506465704 | (37.7352982464866, -122.430506465704) | 2 | 7 | 5 | 63 | 7 | ||
29351 | 121333 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401x Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001103 | 2113984 | 37.7846586481563 | -122.439914057191 | (37.7846586481563, -122.439914057191) | 15 | 6 | 11 | 29490 | 13 | ||||
29534 | 62965 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1039 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23351 | 6008055.81561944 | 2118891.78749794 | 37.7985275574001 | -122.416207279797 | (37.7985275574001, -122.416207279797) | 5 | 1 | 10 | 28858 | 21 | ||
29611 | 60905 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1435 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20695 | 5994562.82090715 | 2105757.04151051 | 37.7616951308 | -122.461943947676 | (37.7616951308, -122.461943947676) | 1 | 5 | 11 | 56 | 12 | ||
29950 | 43947 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
30748 | 97294 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 513 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995614.6 | 2106503.7 | 37.7638057586808 | -122.458360338276 | (37.7638057586808, -122.458360338276) | 15 | 5 | 11 | 56 | 12 | ||||
30895 | 39979 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2145 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1999 12:00:00 AM | Permit Number 41237 | 6006144.69846015 | 2086166.07297413 | 37.7085626554063 | -122.420496156449 | (37.7085626554063, -122.420496156449) | 9 | 7 | 8 | 309 | 39 | |||
31493 | 43957 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
31537 | 60046 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1487 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/1982 12:00:00 AM | Permit Number 19544 | 5988347.05567668 | 2105203.58960339 | 37.7598156946522 | -122.48340093827 | (37.7598156946522, -122.48340093827) | 1 | 8 | 3 | 56 | 35 | ||
31593 | 89364 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 Ocean Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51942 | 5990665.5 | 2095192.3 | 37.7324619562673 | -122.474651985861 | (37.7324619562673, -122.474651985861) | 1 | 8 | 4 | 64 | 40 | ||||
31869 | 61485 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3344 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/1984 12:00:00 AM | Permit Number 21783 | 6004557.13674031 | 2106626.70138922 | 37.764653323261 | -122.427439583281 | (37.764653323261, -122.427439583281) | 8 | 4 | 5 | 28862 | 3 | ||
31887 | 43948 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
31948 | 49311 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46314 | 5988391.39591113 | 2104399.73946123 | 37.7576111203086 | -122.483188666505 | (37.7576111203086, -122.483188666505) | 1 | 8 | 3 | 56 | 35 | |||
32216 | 65720 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28652 | 6000403.76126998 | 2087546.45135602 | 37.7120276638869 | -122.440436436812 | (37.7120276638869, -122.440436436812) | 9 | 7 | 6 | 28861 | 5 | ||
32342 | 31732 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1900x ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49954 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
32363 | 65475 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 139 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28356 | 5994946.1613389 | 2091867.15986048 | 37.7235790361119 | -122.459612079866 | (37.7235790361119, -122.459612079866) | 9 | 8 | 4 | 28861 | 24 | ||
32853 | 99729 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2645 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990840.1 | 2094977 | 37.7318809123737 | -122.474032655501 | (37.7318809123737, -122.474032655501) | 1 | 8 | 4 | 64 | 40 | ||||
32866 | 58358 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1982 12:00:00 AM | Permit Number 17385 | 5995357.79891147 | 2090417.44693178 | 37.719622131539 | -122.458084262322 | (37.719622131539, -122.458084262322) | 9 | 8 | 6 | 28861 | 24 | ||
33001 | 65653 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 21 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28572 | 5997320.52233846 | 2099335.80074368 | 37.7442223795404 | -122.451942942596 | (37.7442223795404, -122.451942942596) | 9 | 7 | 4 | 59 | 40 | ||
33177 | 67101 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1992 12:00:00 AM | Permit Number 768839 | 5995661.29315908 | 2106742.31523698 | 37.7644636177418 | -122.458216113229 | (37.7644636177418, -122.458216113229) | 15 | 5 | 11 | 56 | 12 | |||
33508 | 92764 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
33571 | 48611 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
33668 | 102791 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983413 | 2105597.3 | 37.7606083127672 | -122.500494252669 | (37.7606083127672, -122.500494252669) | 1 | 8 | 3 | 56 | 35 | ||||
34148 | 68359 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 683 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32179 | 5989402.03203954 | 2110700.64294356 | 37.7749704468589 | -122.480154654119 | (37.7749704468589, -122.480154654119) | 11 | 6 | 2 | 55 | 26 | ||
34178 | 68298 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2100 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 3x3 | Permit Number 32107 | 5981719.63070527 | 2100774.89065863 | 37.747267790944 | -122.505993194922 | (37.747267790944, -122.505993194922) | 1 | 8 | 3 | 29491 | 35 | |
34708 | 50631 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1198 Gilman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2003 12:00:00 AM | Permit Number 47223 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
34754 | 101438 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
34848 | 34566 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 165 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38274 | 6009061.45291554 | 2097695.83711319 | 37.7403848997405 | -122.411229362178 | (37.7403848997405, -122.411229362178) | 10 | 7 | 7 | 28859 | 2 |
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) );