trees
8,758 rows where qSpecies_id = 16 sorted by qLegalStatus_id descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 22162 | 87639 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3121 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5997471.09932 | 2112940.69373 | 37.7815865910038 | -122.452403842497 | (37.7815865910038, -122.452403842497) | 15 | 6 | 2 | 54 | 16 | |||
| 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 | ||
| 22675 | 59691 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 185 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | 38 | 4x3 | Permit Number 19118 | 5980952.62035506 | 2112920.61231564 | 37.7805712485973 | -122.509547375915 | (37.7805712485973, -122.509547375915) | 11 | 6 | 2 | 55 | 26 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||||
| 23909 | 2225 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2110X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x6 | 6000786.46841 | 2112787.68364 | 37.7813558468199 | -122.440923297335 | (37.7813558468199, -122.440923297335) | 15 | 5 | 1 | 29490 | 41 | |||
| 24274 | 19563 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6000237.59521 | 2113336.21742 | 37.7828307037077 | -122.442861526711 | (37.7828307037077, -122.442861526711) | 15 | 5 | 1 | 29490 | 16 | |||
| 24449 | 11587 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4033 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5982019.6542 | 2105538.47189 | 37.7603648969096 | -122.505308760532 | (37.7603648969096, -122.505308760532) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 25212 | 8999 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5240 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5990780.2624 | 2112729.94687 | 37.7806223429379 | -122.475535313697 | (37.7806223429379, -122.475535313697) | 11 | 6 | 2 | 54 | 26 | |||
| 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 | ||
| 25587 | 22828 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 81 Turquoise Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X3 | 5999185.2847623 | 2099186.6901982 | 37.7439195907309 | -122.445484301453 | (37.7439195907309, -122.445484301453) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 26870 | 4888 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 810X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1992 12:00:00 AM | 3 | 3X70 | 6009501.94188 | 2090124.3268696 | 37.719619835525 | -122.409172174479 | (37.719619835525, -122.409172174479) | 9 | 3 | 7 | 309 | 28 | ||
| 27360 | 11818 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||
| 27437 | 24801 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7427 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5983939.35899 | 2112366.9019 | 37.7792265883628 | -122.499174063221 | (37.7792265883628, -122.499174063221) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | ||
| 28133 | 8688 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997918.25656 | 2113201.82706 | 37.7823292025673 | -122.450875734122 | (37.7823292025673, -122.450875734122) | 15 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 28419 | 2489 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Roosevelt Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001249.7795025 | 2107415.0969017 | 37.7666304484597 | -122.438935332592 | (37.7666304484597, -122.438935332592) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | ||
| 28619 | 69481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 975 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773682 | 5991289.37358036 | 2104918.32998629 | 37.7592032524136 | -122.473204200451 | (37.7592032524136, -122.473204200451) | 1 | 8 | 4 | 56 | 12 | |
| 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 | |||
| 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 | ||
| 29059 | 111982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Seacliff Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 5988034.92641504 | 2115788.16420519 | 37.788859809462 | -122.485257088915 | (37.788859809462, -122.485257088915) | 11 | 6 | 1 | 55 | 33 | ||||
| 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 | |||
| 29291 | 117118 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4006 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Permit Number 778373 | 6001804.25600707 | 2102958.17712895 | 37.7544243620634 | -122.436698432015 | (37.7544243620634, -122.436698432015) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||
| 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 | |||
| 30328 | 9103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5701X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989355.17851 | 2112602.13726 | 37.7801886990062 | -122.480455945279 | (37.7801886990062, -122.480455945279) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 30951 | 957 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1528 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3X3 | 6001955.00111 | 2093277.90628 | 37.7278531638615 | -122.435484665703 | (37.7278531638615, -122.435484665703) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 31512 | 27291 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Chilton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001708.3008261 | 2095817.8256998 | 37.7348131857142 | -122.436519230882 | (37.7348131857142, -122.436519230882) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||
| 31552 | 8997 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5240 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5990780.2624 | 2112729.94687 | 37.7806223429379 | -122.475535313697 | (37.7806223429379, -122.475535313697) | 11 | 6 | 2 | 54 | 26 | |||
| 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 | ||
| 32449 | 22152 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1570X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015582.155926 | 2098251.094071 | 37.7422730663447 | -122.388721900675 | (37.7422730663447, -122.388721900675) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 33374 | 21825 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2742 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008296.21715 | 2122224.91462 | 37.8076930017751 | -122.415611531478 | (37.8076930017751, -122.415611531478) | 5 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 33645 | 18710 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 Roosevelt Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001702.8694074 | 2107531.8635154 | 37.7669768293108 | -122.437376538243 | (37.7669768293108, -122.437376538243) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||
| 34860 | 112019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 5995513.1 | 2106277.2 | 37.7631780147852 | -122.458694995111 | (37.7631780147852, -122.458694995111) | 15 | 5 | 4 | 63 | 12 | ||||
| 35276 | 64190 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 125 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/1987 12:00:00 AM | Permit Number 769009 | 5992040.0828487 | 2092899.25013025 | 37.7262453651459 | -122.469732891349 | (37.7262453651459, -122.469732891349) | 9 | 8 | 4 | 59 | 40 | |||
| 35719 | 61398 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3487 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1984 12:00:00 AM | Permit Number 21319 | 6003657.32089146 | 2106524.69666407 | 37.76432230952 | -122.430544527276 | (37.76432230952, -122.430544527276) | 8 | 4 | 5 | 28862 | 3 | |||
| 35831 | 65201 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 368 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27187 | 6004262.20736892 | 2091022.97886406 | 37.7217923991734 | -122.427348035237 | (37.7217923991734, -122.427348035237) | 9 | 7 | 6 | 28861 | 5 | ||
| 35963 | 64524 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1580 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25406 | 6015179.7795302 | 2095406.78838863 | 37.7344408760241 | -122.389914569118 | (37.7344408760241, -122.389914569118) | 10 | 3 | 8 | 58 | 1 | ||
| 35982 | 35672 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 526 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38981 | 5995332.07461936 | 2111959.28107373 | 37.7787691147608 | -122.459732689005 | (37.7787691147608, -122.459732689005) | 11 | 6 | 2 | 54 | 11 | ||||
| 36013 | 66991 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30344 | 5995660.03452359 | 2090845.59111615 | 37.720815075264 | -122.45707050247 | (37.720815075264, -122.45707050247) | 9 | 8 | 6 | 28861 | 24 | ||
| 36310 | 29399 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2923X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014585.06458 | 2090356.48444 | 37.7205407559713 | -122.391617732808 | (37.7205407559713, -122.391617732808) | 10 | 3 | 8 | 58 | 1 | |||
| 36676 | 22150 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1570X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015582.155926 | 2098251.094071 | 37.7422730663447 | -122.388721900675 | (37.7422730663447, -122.388721900675) | 10 | 3 | 8 | 58 | 1 | |||
| 37082 | 10908 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1994 12:00:00 AM | 18 | 3X4 | 6017092.2050139 | 2095860.328118 | 37.7357920792709 | -122.383334180509 | (37.7357920792709, -122.383334180509) | 10 | 3 | 8 | 58 | 1 | ||
| 37587 | 25325 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5998027.88462 | 2091524.2464 | 37.7228142021203 | -122.4489344645 | (37.7228142021203, -122.4489344645) | 9 | 7 | 4 | 28861 | 24 | |||
| 37598 | 24660 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3299X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5997079.4484 | 2112916.53023 | 37.7814977986133 | -122.453757014981 | (37.7814977986133, -122.453757014981) | 11 | 6 | 2 | 54 | 16 |
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) );