trees
140 rows where qSpecies_id = 125 sorted by qAddress
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168716 | 67115 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1000 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30534 | 5998132.38450691 | 2106832.35950645 | 37.7648525393869 | -122.449675814605 | (37.7648525393869, -122.449675814605) | 15 | 5 | 11 | 29492 | 9 | ||
| 27815 | 35578 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1001 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38947 | 6006352.71975705 | 2103759.98649975 | 37.7568833861691 | -122.421025568698 | (37.7568833861691, -122.421025568698) | 2 | 4 | 7 | 28859 | 19 | ||
| 101050 | 6723 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1200X Fairfax Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
| 71419 | 66598 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1243 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | Permit Number 29791 | 6007978.50985665 | 2115821.60445069 | 37.7900932467238 | -122.416257217788 | (37.7900932467238, -122.416257217788) | 13 | 1 | 10 | 28858 | 21 | ||
| 183479 | 36113 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.7647227313074 | -122.471822291529 | (37.7647227313074, -122.471822291529) | 11 | 8 | 11 | 56 | 12 | ||
| 134050 | 6249 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1310X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2013 12:00:00 AM | 18 | 4X4 | 6004670.79192 | 2113352.05321 | 37.7831259277051 | -122.427525647587 | (37.7831259277051, -122.427525647587) | 7 | 9 | 11 | 28858 | 41 | ||
| 59855 | 36126 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39222 | 5993608.512381 | 2106430.08869154 | 37.7634881557628 | -122.46529338012 | (37.7634881557628, -122.46529338012) | 1 | 8 | 11 | 56 | 12 | ||
| 30157 | 4556 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1340X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 6004655.03099 | 2113461.96066 | 37.7834268147862 | -122.427588006915 | (37.7834268147862, -122.427588006915) | 7 | 9 | 11 | 28858 | 41 | ||
| 149983 | 6785 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1360 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 6x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
| 67786 | 6807 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1395 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | ||
| 27242 | 49196 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 27894 | 49192 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 77536 | 49194 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 125086 | 49193 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 130084 | 49199 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 133447 | 49195 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 145444 | 49190 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 145459 | 49191 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 146656 | 49197 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |||
| 186870 | 49200 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 140 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | 3x3 | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.418256071727 | (37.7713226032013, -122.418256071727) | 8 | 2 | 9 | 28853 | 19 | |
| 144292 | 37417 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1406 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 39895 | 6001966.85277742 | 2099994.31437339 | 37.7462955388548 | -122.435924071348 | (37.7462955388548, -122.435924071348) | 2 | 7 | 5 | 63 | 22 | ||
| 36011 | 66456 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 144 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2008 12:00:00 AM | 3x3 | Permit Number 51700 | 6009019.86661618 | 2097810.11966481 | 37.7406963622889 | -122.411381223301 | (37.7406963622889, -122.411381223301) | 10 | 7 | 7 | 28859 | 2 | ||
| 129937 | 6843 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1445 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2007 12:00:00 AM | 6 | 3X3 | 6016186 | 2097583 | 37.7404720645711 | -122.386587398583 | (37.7404720645711, -122.386587398583) | 10 | 3 | 8 | 58 | 1 | ||
| 19639 | 6826 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 20856 | 6820 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 21328 | 6821 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 23319 | 6827 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 42767 | 6830 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 131896 | 6822 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 78475 | 6840 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1469 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016172 | 2097718 | 37.7408419720165 | -122.386645216998 | (37.7408419720165, -122.386645216998) | 10 | 3 | 8 | 58 | 1 | ||
| 74647 | 6837 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1475 FAIRFAX AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | 6 | 3X3 | 6016157 | 2097767 | 37.7409756855874 | -122.386700497992 | (37.7409756855874, -122.386700497992) | 10 | 3 | 8 | 58 | 1 | ||
| 38741 | 32927 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1550 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.399198840377 | (37.7650556499946, -122.399198840377) | 14 | 3 | 8 | 28856 | 20 | |||
| 97443 | 228436 | Undocumented 4 | Hymenosporum flavum :: Sweet Shade 125 | 160 Church St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6004092.7276 | 2107966.58323 | 37.7683060383318 | -122.42914139496 | (37.7683060383318, -122.42914139496) | 7 | 9 | 5 | 28862 | 3 | |||
| 156172 | 93230 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 160 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092 | 2108018 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | 7 | 9 | 5 | 28862 | 3 | ||
| 190839 | 93231 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 160 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092 | 2108018 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | 7 | 9 | 5 | 28862 | 3 | ||
| 51465 | 15297 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1625 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/1995 12:00:00 AM | 0 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | 8 | 2 | 9 | 28853 | 19 | ||
| 130963 | 15296 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 1625 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6007067.55267 | 2109351.08159 | 37.7722754939412 | -122.4189499451 | (37.7722754939412, -122.4189499451) | 8 | 2 | 9 | 28853 | 19 | ||
| 37499 | 49457 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 175 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | 6 | 2 | 9 | 28856 | 34 | |
| 41025 | 49456 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 175 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | 6 | 2 | 9 | 28856 | 34 | |
| 66874 | 49459 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 175 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | 6 | 2 | 9 | 28856 | 34 | |
| 157255 | 48637 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | 1 | 5 | 4 | 56 | 12 | ||
| 183390 | 48636 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | 1 | 5 | 4 | 56 | 12 |
| 92541 | 122809 | Undocumented 4 | Hymenosporum flavum :: Sweet Shade 125 | 1801 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005422 | 2107198 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | 8 | 4 | 5 | 28853 | 19 | ||||
| 128680 | 122811 | Undocumented 4 | Hymenosporum flavum :: Sweet Shade 125 | 1801 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005422 | 2107198 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | 8 | 4 | 5 | 28853 | 19 | ||||
| 191744 | 122810 | Undocumented 4 | Hymenosporum flavum :: Sweet Shade 125 | 1801 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005422 | 2107198 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | 8 | 4 | 5 | 28853 | 19 | ||||
| 103367 | 36675 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1815 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 15 | 3x3 | Permit Number 39480 | 6005408.20742805 | 2107215.17723629 | 37.7663172364539 | -122.42453781561 | (37.7663172364539, -122.42453781561) | 8 | 4 | 5 | 28853 | 19 | |
| 81073 | 44081 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.7656631551561 | -122.44681260549 | (37.7656631551561, -122.44681260549) | 15 | 5 | 11 | 29492 | 9 | |||
| 162316 | 44082 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 184 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.7656631551561 | -122.44681260549 | (37.7656631551561, -122.44681260549) | 15 | 5 | 11 | 29492 | 9 | |||
| 184615 | 30691 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52599 | 6006108.61199537 | 2109713.28983155 | 37.7732159867663 | -122.422292750625 | (37.7732159867663, -122.422292750625) | 7 | 9 | 11 | 28852 | 10 | ||
| 121487 | 10264 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 212 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005102.22381 | 2109572.21051 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | 7 | 9 | 11 | 28852 | 10 | |||
| 158192 | 10266 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 212 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005102.22381 | 2109572.21051 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | 7 | 9 | 11 | 28852 | 10 | |||
| 181634 | 10265 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 212 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005102.22381 | 2109572.21051 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | 7 | 9 | 11 | 28852 | 10 | |||
| 87456 | 93314 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 227 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004180 | 2107540 | 37.7671396838414 | -122.42880911314 | (37.7671396838414, -122.42880911314) | 8 | 4 | 5 | 28862 | 3 | ||
| 159619 | 61667 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 235 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2016 12:00:00 AM | 3 | Permit Number 777577 | 6004178.04494694 | 2107496.55994699 | 37.7670202972864 | -122.428812778191 | (37.7670202972864, -122.428812778191) | 8 | 4 | 5 | 28862 | 3 | |
| 85183 | 93313 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 241 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004184 | 2107469 | 37.766944961369 | -122.428790215647 | (37.766944961369, -122.428790215647) | 8 | 4 | 5 | 28862 | 3 | ||
| 131508 | 93312 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 245 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004185 | 2107449 | 37.7668901027922 | -122.428785330871 | (37.7668901027922, -122.428785330871) | 8 | 4 | 5 | 28862 | 3 | ||
| 74536 | 35327 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.419999156575 | (37.759397576581, -122.419999156575) | 2 | 4 | 7 | 28859 | 19 | ||
| 98878 | 93311 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 253 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004187 | 2107409 | 37.7667803856364 | -122.428775561342 | (37.7667803856364, -122.428775561342) | 8 | 4 | 5 | 28862 | 3 | ||
| 99824 | 42081 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 254 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42391 | 6008092.42384606 | 2100220.76756697 | 37.7472634047037 | -122.41475853877 | (37.7472634047037, -122.41475853877) | 2 | 7 | 7 | 28859 | 2 | ||
| 63830 | 32861 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | 2 | 4 | 5 | 28862 | 22 | ||
| 130266 | 29880 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 270 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6006057.16025 | 2108040.46288 | 37.7686199019247 | -122.42235185 | (37.7686199019247, -122.42235185) | 8 | 4 | 5 | 28853 | 19 | ||
| 35384 | 65015 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 278 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2011 12:00:00 AM | 3 | 2x3 | Permit Number 768137 | 6007725.96636 | 2097829.89859682 | 37.7406780141402 | -122.415856451174 | (37.7406780141402, -122.415856451174) | 2 | 7 | 7 | 28859 | 2 | |
| 59645 | 36994 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39614 | 6009898.14777577 | 2102820.5904951 | 37.754503234678 | -122.408697833051 | (37.754503234678, -122.408697833051) | 2 | 4 | 7 | 28859 | 19 | ||
| 113501 | 93232 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 292 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004136 | 2107205 | 37.7662173642146 | -122.42893741621 | (37.7662173642146, -122.42893741621) | 8 | 4 | 5 | 28862 | 3 | ||
| 141012 | 39284 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) | 8 | 4 | 7 | 28859 | 19 |
| 173088 | 39301 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) | 8 | 4 | 7 | 28859 | 19 |
| 54109 | 49189 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | 8 | 4 | 5 | 28853 | 19 | |||
| 181586 | 93234 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 306 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | 8 | 4 | 5 | 28862 | 3 | ||
| 46195 | 93310 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 307 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004202 | 2107132 | 37.7660206593376 | -122.428703930527 | (37.7660206593376, -122.428703930527) | 8 | 4 | 5 | 28862 | 3 | ||
| 187273 | 93309 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 309 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6004203 | 2107120 | 37.7659877668224 | -122.428699616217 | (37.7659877668224, -122.428699616217) | 8 | 4 | 5 | 28862 | 3 | ||
| 140015 | 93308 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 315 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2015 01:54:00 PM | 3 | 3x3 | 6004205 | 2107085 | 37.7658917784387 | -122.428690203394 | (37.7658917784387, -122.428690203394) | 8 | 4 | 5 | 28862 | 3 | ||
| 177435 | 27324 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 320 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 09:31:00 AM | 3 | 4x4 | 6004588.93351 | 2109631.91786 | 37.7729067207461 | -122.427543724178 | (37.7729067207461, -122.427543724178) | 7 | 9 | 11 | 28852 | 10 | ||
| 33786 | 35764 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3321 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558787 | (37.7633323895219, -122.41994558787) | 8 | 4 | 7 | 28859 | 19 | ||
| 153476 | 35763 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3321 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558787 | (37.7633323895219, -122.41994558787) | 8 | 4 | 7 | 28859 | 19 | ||
| 158443 | 91210 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 333 Haight St | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 6004540.59043 | 2109422.99046 | 37.7723303224715 | -122.427696060061 | (37.7723303224715, -122.427696060061) | 7 | 9 | 11 | 28852 | 10 | |||
| 97099 | 93183 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 353 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | 6004447 | 2109433 | 37.7723525117512 | -122.428020511442 | (37.7723525117512, -122.428020511442) | 7 | 9 | 11 | 28852 | 10 | ||
| 73470 | 43634 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.421724772623 | (37.7488955027959, -122.421724772623) | 2 | 4 | 5 | 28859 | 19 | ||
| 97652 | 91209 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 365 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004404.0966 | 2109354.51914 | 37.7721345950401 | -122.428163324287 | (37.7721345950401, -122.428163324287) | 7 | 9 | 11 | 28852 | 10 | ||
| 90793 | 48986 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 372 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 46173 | 6004094.60882476 | 2100160.1254271 | 37.7468714608035 | -122.428578362797 | (37.7468714608035, -122.428578362797) | 2 | 7 | 5 | 63 | 22 | ||
| 72566 | 35493 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38903 | 6005339.71347882 | 2104322.52965211 | 37.7583708422124 | -122.424568939806 | (37.7583708422124, -122.424568939806) | 2 | 4 | 5 | 28859 | 19 | ||
| 118347 | 91208 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 379 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2011 12:00:00 AM | 3 | 3x3 | 6004350.8664 | 2109396.58467 | 37.772247084848 | -122.428350450647 | (37.772247084848, -122.428350450647) | 7 | 9 | 11 | 28852 | 10 | ||
| 177014 | 91116 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3838 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2009 12:00:00 AM | 3 | 4x4 | Permit Number 52006 | 6004047 | 2104828 | 37.7596856536801 | -122.429075753932 | (37.7596856536801, -122.429075753932) | 2 | 4 | 5 | 28862 | 3 |
| 188035 | 91207 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004300.94327 | 2109389.6362 | 37.7722251810056 | -122.428522643794 | (37.7722251810056, -122.428522643794) | 7 | 9 | 11 | 28852 | 10 | ||
| 161273 | 14967 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 395 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 6016770.71768 | 2097736.29352 | 37.7409253302671 | -122.384576328932 | (37.7409253302671, -122.384576328932) | 10 | 3 | 8 | 58 | 1 | ||
| 99382 | 71197 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 3966 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53734 | 6004099.24997097 | 2100745.29337187 | 37.7484784588463 | -122.4286040195 | (37.7484784588463, -122.4286040195) | 2 | 4 | 5 | 28862 | 22 | |
| 31811 | 91206 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 397 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004278.56897 | 2109349.66843 | 37.7721141730556 | -122.428597188956 | (37.7721141730556, -122.428597188956) | 7 | 9 | 11 | 28852 | 10 | ||
| 135011 | 27335 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2005 12:00:00 AM | 12 | 3X3 | 6004279.72317 | 2109472.24988 | 37.7724508171595 | -122.428601935914 | (37.7724508171595, -122.428601935914) | 7 | 9 | 11 | 28852 | 10 | ||
| 80967 | 91220 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 401 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6004167.50456 | 2109371.06405 | 37.7721666341778 | -122.428982895538 | (37.7721666341778, -122.428982895538) | 7 | 9 | 11 | 29492 | 10 | ||
| 76044 | 91193 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 402 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | 3x3 | 6004165.42779 | 2109456.3421 | 37.7724006693447 | -122.428996160396 | (37.7724006693447, -122.428996160396) | 7 | 9 | 11 | 29492 | 10 | ||
| 97290 | 91194 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 4 | 3x3 | 6004119.82913 | 2109461.1016 | 37.7724111565911 | -122.42915422992 | (37.7724111565911, -122.42915422992) | 7 | 9 | 11 | 29492 | 10 | ||
| 36818 | 91219 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 413 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6004113.38754 | 2109363.53225 | 37.7721428903176 | -122.429169553725 | (37.7721428903176, -122.429169553725) | 7 | 9 | 11 | 29492 | 10 | ||
| 44102 | 32443 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 4167 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36965 | 6001261.23901245 | 2105800.41566985 | 37.7621975832428 | -122.438779978808 | (37.7621975832428, -122.438779978808) | 15 | 5 | 5 | 28862 | 3 | ||
| 192357 | 91218 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 421 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6004113.63754 | 2109346.83608 | 37.7720970608608 | -122.429167498253 | (37.7720970608608, -122.429167498253) | 7 | 9 | 11 | 29492 | 10 | ||
| 76844 | 91195 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 422 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2011 12:00:00 AM | 1 | 3x3 | 6004087.9204 | 2109490.98672 | 37.7724914074662 | -122.429266736662 | (37.7724914074662, -122.429266736662) | 7 | 9 | 11 | 29492 | 10 | ||
| 180525 | 32828 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.437246939262 | (37.7511683628484, -122.437246939262) | 2 | 4 | 5 | 28862 | 22 | ||
| 134462 | 32823 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 37181 | 6001484.39499205 | 2102303.82093127 | 37.7526094742242 | -122.43775772935 | (37.7526094742242, -122.43775772935) | 2 | 4 | 5 | 28862 | 22 | ||
| 159504 | 60428 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 427 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30410 | 6003803.88116194 | 2098922.41171053 | 37.7434565282269 | -122.429495418306 | (37.7434565282269, -122.429495418306) | 2 | 7 | 5 | 63 | 22 | ||
| 25489 | 91196 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 430 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | 3x3 | 6004046.01956 | 2109450.82866 | 37.772378771061 | -122.429408811542 | (37.772378771061, -122.429408811542) | 7 | 9 | 11 | 29492 | 10 | ||
| 15619 | 37026 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 432 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.7467892731968 | -122.429947677166 | (37.7467892731968, -122.429947677166) | 2 | 7 | 5 | 63 | 22 | ||
| 83340 | 91197 | DPW Maintained 1 | Hymenosporum flavum :: Sweet Shade 125 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003996.81297 | 2109443.98025 | 37.772357180985 | -122.429578533241 | (37.772357180985, -122.429578533241) | 7 | 9 | 11 | 29492 | 10 |
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) );