Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48536 | 48536 | 54077 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1416 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1972 12:00:00 AM | 12 | Permit Number 9800 | 5982488.8605 | 2105444.4291 | 37.7601342805878 | -122.503679056793 | (37.7601342805878, -122.503679056793) | ||
| 66758 | 66758 | 54071 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1650 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 17 | Permit Number 9794 | 5981301.6578 | 2103844.8448 | 37.7556724054432 | -122.50766625573 | (37.7556724054432, -122.50766625573) | ||
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 129286 | 129286 | 53959 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9674 | 6004995.7689664 | 2119500.86037361 | 37.800027377944495 | -122.42683940106701 | (37.8000273779445, -122.426839401067) | |||
| 136240 | 136240 | 53866 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1746 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 13 | Permit Number 9576 | 5983496.0301 | 2103256.2411 | 37.754185295753295 | -122.50003403412201 | (37.7541852957533, -122.500034034122) | ||
| 124556 | 124556 | 53759 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 492x Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | Permit Number 9439 845-849 Diamond St | 6001965.94583867 | 2101505.01209507 | 37.750443505469605 | -122.43603528995001 | (37.7504435054696, -122.43603528995) | |||
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
| 1412 | 1412 | 120316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779745 | 5988743.0107 | 2113100.3508099997 | 37.7815210589505 | -122.482610207249 | (37.7815210589505, -122.482610207249) | |
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 717 | 717 | 106656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | |
| 720 | 720 | 104746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989767.16587 | 2110527.4876599996 | 37.774516219561704 | -122.478878924469 | (37.7745162195617, -122.478878924469) | |
| 35 | 35 | 183515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2562 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779639 | 5988336.7554 | 2097879.9474 | 37.7397063254514 | -122.482899813956 | (37.7397063254514, -122.482899813956) | |
| 654 | 654 | 122328 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3015 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779630 | 5996535.0 | 2111432.0 | 37.7773904414434 | -122.455533202662 | (37.7773904414434, -122.455533202662) | |
| 10678 | 10678 | 116741 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1631 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779477 | 5983734.6502 | 2104037.3849 | 37.7563440999856 | -122.499266557723 | (37.7563440999856, -122.499266557723) | |
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 9861 | 9861 | 118901 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980648.88475 | 2109606.3629099997 | 37.7714533859213 | -122.510351791198 | (37.7714533859213, -122.510351791198) | |
| 9874 | 9874 | 118902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980610.1556400005 | 2109606.19987 | 37.771450653513206 | -122.510485742594 | (37.7714506535132, -122.510485742594) | |
| 9808 | 9808 | 121557 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | |
| 9810 | 9810 | 121556 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | ||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 60911 | 60911 | 121797 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 109843 | 109843 | 121799 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 125490 | 125490 | 121796 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 305 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | ||
| 5802 | 5802 | 122541 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2233 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779046 | 6001437.2497 | 2113869.2014 | 37.7843624618515 | -122.438749438347 | (37.7843624618515, -122.438749438347) | |
| 77895 | 77895 | 105191 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.0538800005 | 2111041.25056 | 37.77545129327579 | -122.507047101274 | (37.7754512932758, -122.507047101274) | |
| 121287 | 121287 | 105189 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981634.44946 | 2111075.87113 | 37.7755463155962 | -122.50705176084101 | (37.7755463155962, -122.507051760841) | |
| 127652 | 127652 | 105190 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.135559999 | 2111057.61363 | 37.7754962262709 | -122.50704803283101 | (37.7754962262709, -122.507048032831) | |
| 143850 | 143850 | 50968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 3x3 | Permit Number 778895 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | ||
| 143633 | 143633 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778784 | 5981521.320719999 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | |||
| 5601 | 5601 | 116211 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996580.5135 | 2114939.45555 | 37.7870235965959 | -122.455629343026 | (37.7870235965959, -122.455629343026) | |
| 7159 | 7159 | 116209 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996627.1701 | 2114945.18052 | 37.787041993130295 | -122.455468336508 | (37.7870419931303, -122.455468336508) | |
| 7502 | 7502 | 116210 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996604.94532 | 2114941.4574599997 | 37.787030495305 | -122.455544959643 | (37.787030495305, -122.455544959643) | |
| 143205 | 143205 | 117682 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7800 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | Width 3ft | Permit Number 778742 | 5982589.466109999 | 2112438.09785 | 37.779342790231794 | -122.503849096172 | (37.7793427902318, -122.503849096172) | |
| 13181 | 13181 | 117441 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1204 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778732 | 5989885.5669 | 2107139.7037 | 37.765221164359495 | -122.47822160390498 | (37.7652211643595, -122.478221603905) | |
| 12762 | 12762 | 116742 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1638 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x3 | Permit Number 778698 | 5983780.8141 | 2103988.0199 | 37.756211265636296 | -122.499103262084 | (37.7562112656363, -122.499103262084) | |
| 93516 | 93516 | 121154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 112601 | 112601 | 97287 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | ||
| 124262 | 124262 | 121153 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 11465 | 11465 | 107858 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2908 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778432 | 5981789.5382 | 2096536.8762 | 37.735635490547 | -122.505437384685 | (37.735635490547, -122.505437384685) | |
| 78140 | 78140 | 108270 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3198 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778418 | 5993567.71806 | 2110075.4730599998 | 37.7734950644816 | -122.46569933848 | (37.7734950644816, -122.46569933848) | |
| 88289 | 88289 | 61437 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 788 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | Permit Number 778418 | 5993530.07441 | 2110197.53457 | 37.7738280413865 | -122.46583842282101 | (37.7738280413865, -122.465838422821) | ||
| 118298 | 118298 | 108269 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3198 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778418 | 5993591.00461 | 2110079.42725 | 37.7735072647955 | -122.46561907488599 | (37.7735072647955, -122.465619074886) | |
| 11593 | 11593 | 116739 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1678 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778366 | 5983788.3957 | 2103743.2164 | 37.755539548337204 | -122.49905895584999 | (37.7555395483372, -122.49905895585) | |||
| 143696 | 143696 | 57758 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/1977 12:00:00 AM | Permit Number 778232 | 5996349.7575948 | 2095933.20555752 | 37.73482403404479 | -122.45505379547 | (37.7348240340448, -122.45505379547) | |||
| 117435 | 117435 | 116953 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778114 | 5993978.14384 | 2115037.85395 | 37.7871440899951 | -122.464640036112 | (37.7871440899951, -122.464640036112) | |
| 11510 | 11510 | 107860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3667 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777933 | 5981683.9506 | 2096685.2741 | 37.7360367363779 | -122.505813433386 | (37.7360367363779, -122.505813433386) | |||
| 85539 | 85539 | 115935 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 76 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777731 | 5993976.17903 | 2115057.9216 | 37.7871990770116 | -122.46464829162501 | (37.7871990770116, -122.464648291625) | |
| 80171 | 80171 | 114418 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 824 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777680 | 5982642.49578 | 2110126.6105299997 | 37.7729992386667 | -122.503494435004 | (37.7729992386667, -122.503494435004) | |
| 83521 | 83521 | 115719 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3976 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x5 | Permit Number 777657 | 5995670.79935 | 2115513.64773 | 37.7885479271258 | -122.45881831615499 | (37.7885479271258, -122.458818316155) | |
| 148813 | 148813 | 115720 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3976 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x5 | Permit Number 777657 | 5995656.1105 | 2115513.66642 | 37.7885471341329 | -122.458869138348 | (37.7885471341329, -122.458869138348) | ||
| 87369 | 87369 | 115776 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 31 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 777578 | 6000914.0 | 2104885.0 | 37.759664315239796 | -122.43991530525801 | (37.7596643152398, -122.439915305258) | ||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 12647 | 12647 | 115149 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2430 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | Permit Number 777450 | 5987687.2149 | 2098724.2655 | 37.7419867848349 | -122.48520755477199 | (37.7419867848349, -122.485207554772) | ||
| 11284 | 11284 | 105132 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1619 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 777355 | 5981562.16 | 2104041.1764 | 37.756226819608 | -122.50677993398399 | (37.756226819608, -122.506779933984) | ||
| 115892 | 115892 | 95277 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 554 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 12:00:00 AM | 3 | 5x7 | Permit Number 777230 | 5994096.260869999 | 2111723.67308 | 37.778051054367204 | -122.463990712248 | (37.7780510543672, -122.463990712248) | |
| 48961 | 48961 | 114417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 818 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 17 | 3x3 | Permit Number 777178 | 5982641.81741 | 2110164.71774 | 37.7731038301224 | -122.50349960390601 | (37.7731038301224, -122.503499603906) | |
| 141348 | 141348 | 115094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1460 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777177 | 5999642.2 | 2107532.2 | 37.766860388537104 | -122.444504069146 | (37.7668603885371, -122.444504069146) | |||
| 47698 | 47698 | 114416 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 814 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 16 | 3x3 | Permit Number 777152 | 5982641.87614 | 2110195.3692 | 37.7731879935855 | -122.50350167093399 | (37.7731879935855, -122.503501670934) | |
| 94344 | 94344 | 114062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) | |||
| 138802 | 138802 | 114064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | |||
| 139818 | 139818 | 114063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 83432 | 83432 | 113936 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 EL CAMINO DEL MAR | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776988 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | |||
| 98366 | 98366 | 120122 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1426X Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776978 | 6001386.0 | 2099547.0 | 37.7450343054892 | -122.437900552772 | (37.7450343054892, -122.437900552772) | |
| 105616 | 105616 | 120120 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776978 | 6001710.0 | 2099417.0 | 37.744695775282004 | -122.436770916391 | (37.744695775282, -122.436770916391) | |
| 105114 | 105114 | 113094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5725 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776952 | 6000738.0 | 2097078.0 | 37.7382181444182 | -122.43996421610001 | (37.7382181444182, -122.4399642161) | ||
| 117971 | 117971 | 112810 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 118854 | 118854 | 112809 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 157284 | 157284 | 113297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 162 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776713 | 5991196.72746 | 2114338.44012 | 37.7850629536775 | -122.47421197891501 | (37.7850629536775, -122.474211978915) | |
| 32416 | 32416 | 111290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 285 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776047 | 5990541.73439 | 2113523.7121099997 | 37.7827879717093 | -122.476418488313 | (37.7827879717093, -122.476418488313) | |
| 87082 | 87082 | 110870 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 343X AUSTIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775635 | 6005575.0 | 2115207.0 | 37.7882702532087 | -122.424529439646 | (37.7882702532087, -122.424529439646) | |||
| 95751 | 95751 | 110523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775559 | 6001085.0 | 2106026.0 | 37.762806954373104 | -122.439405692132 | (37.7628069543731, -122.439405692132) | |||
| 78781 | 78781 | 121184 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 80352 | 80352 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 89056 | 89056 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104617 | 104617 | 121185 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 123005 | 123005 | 121182 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 142656 | 142656 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 189120 | 189120 | 98169 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 19 | 3x3 | Permit Number 775039 | 6000613.54695 | 2116154.22533 | 37.7905896504327 | -122.44176320452299 | (37.7905896504327, -122.441763204523) | |
| 90642 | 90642 | 108476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 104770 | 104770 | 108475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 119669 | 119669 | 108477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 83799 | 83799 | 108198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 808 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2014 12:00:00 AM | 3 | 2x2 | Permit Number 774168 | 5999486.009 | 2095579.2645400001 | 37.7340316201973 | -122.444185299389 | (37.7340316201973, -122.444185299389) | |
| 61688 | 61688 | 57206 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2202 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1975 12:00:00 AM | Permit Number 774014 | 6000908.32678769 | 2115906.78943665 | 37.7899270475037 | -122.44072552972 | (37.7899270475037, -122.44072552972) | |||
| 93052 | 93052 | 107928 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 95894 | 95894 | 107924 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 120984 | 120984 | 108301 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2898 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773671 | 6000896.59861 | 2115909.1323 | 37.7899328124933 | -122.440766276199 | (37.7899328124933, -122.440766276199) | ||||
| 98593 | 98593 | 107148 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 773613 | 5994730.9 | 2106634.4 | 37.7641138048158 | -122.46142624076599 | (37.7641138048158, -122.461426240766) | ||
| 88103 | 88103 | 100398 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 204 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.46527922129101 | (37.7585961040831, -122.465279221291) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");