trees
339 rows where qSpecies_id = 30 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
qLegalStatus_id ✖
- DPW Maintained 321
- Permitted Site 11
- Undocumented 6
- Significant Tree 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2725 | 118348 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:19:00 AM | 3 | |||||||||||||
3534 | 118354 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:05:00 AM | 3 | |||||||||||||
8707 | 118349 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:43:00 AM | 3 | |||||||||||||
9161 | 118352 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:56:00 AM | 3 | |||||||||||||
10576 | 118350 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:53:00 AM | 3 | |||||||||||||
14601 | 118347 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:39:00 AM | 3 | |||||||||||||
15770 | 118355 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:48:00 AM | 3 | |||||||||||||
18813 | 118351 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:32:00 AM | 3 | |||||||||||||
18821 | 118346 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:47:00 AM | 3 | |||||||||||||
19189 | 118353 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:58:00 AM | 3 | |||||||||||||
6358 | 208585 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1424 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784722 | 5993062.7204 | 2105752.14993 | 37.7615952234535 | -122.467131790705 | (37.7615952234535, -122.467131790705) | 1 | 8 | 4 | 56 | 12 | |
190176 | 184203 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.7594128206633 | -122.500400782356 | (37.7594128206633, -122.500400782356) | 1 | 8 | 3 | 56 | 35 | |||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
22553 | 187785 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1740 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.398915128835 | (37.7599511143744, -122.398915128835) | 10 | 3 | 8 | 28856 | 29 | |||
28727 | 201712 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6015351.33364 | 2088303.0821 | 37.7149450173645 | -122.388825682463 | (37.7149450173645, -122.388825682463) | 10 | 3 | 8 | 58 | 1 | |||
34481 | 201714 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.7151118613908 | -122.388945312084 | (37.7151118613908, -122.388945312084) | 10 | 3 | 8 | 58 | 1 | |||
44991 | 187786 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6015560.61147 | 2097934.79581 | 37.7414033822515 | -122.388774319486 | (37.7414033822515, -122.388774319486) | 10 | 3 | 8 | 58 | 1 | ||||
48962 | 187787 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6015518.87332 | 2097965.19798 | 37.7414845469671 | -122.388920758811 | (37.7414845469671, -122.388920758811) | 10 | 3 | 8 | 58 | 1 | ||||
80085 | 201713 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015343.41284 | 2088314.94317 | 37.7149771465452 | -122.3888538879 | (37.7149771465452, -122.3888538879) | 10 | 3 | 8 | 58 | 1 | |||
136892 | 201711 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015357.64919 | 2088292.55339 | 37.7149164576082 | -122.388803118478 | (37.7149164576082, -122.388803118478) | 10 | 3 | 8 | 58 | 1 | |||
150560 | 201715 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015296.60638 | 2088393.85947 | 37.715191240972 | -122.389021178889 | (37.715191240972, -122.389021178889) | 10 | 3 | 8 | 58 | 1 | |||
162980 | 96193 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
11084 | 187784 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 35 | Front Yard : Yard | Tree | Private 2 | 4 | 6014258.31464 | 2106694.98019 | 37.7653847111611 | -122.393890307196 | (37.7653847111611, -122.393890307196) | 14 | 3 | 8 | 28856 | 20 | ||||
28021 | 187781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | 14 | 3 | 8 | 310 | 29 | ||||
60003 | 187783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 26 | Front Yard : Yard | Tree | Private 2 | 4 | 6014314.48936 | 2106550.7653 | 37.7649918504189 | -122.393685915597 | (37.7649918504189, -122.393685915597) | 14 | 3 | 8 | 310 | 29 | ||||
135542 | 187782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 14 | Front Yard : Yard | Tree | Private 2 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319858 | -122.393639589702 | (37.764680319858, -122.393639589702) | 14 | 3 | 8 | 310 | 29 | ||||
49439 | 37574 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 30 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/2014 12:00:00 AM | 3 | Permit Number 773155 | 6001973.00287599 | 2105680.02476784 | 37.7619074866084 | -122.436309645561 | (37.7619074866084, -122.436309645561) | 15 | 4 | 5 | 28862 | 3 | |
168740 | 221570 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.7686889012963 | -122.437411868978 | (37.7686889012963, -122.437411868978) | 15 | 5 | 5 | 29492 | 3 | |||
813 | 221494 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 2 | 3x3 | Permit Number 56125 | 6005589.49697 | 2105398.29386 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | 2 | 4 | 5 | 28859 | 19 | |
981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
1071 | 240683 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005765.02468 | 2102281.28975 | 37.7527900818195 | -122.422952946818 | (37.7527900818195, -122.422952946818) | 2 | 4 | 5 | 28859 | 19 | ||
1553 | 221523 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005797.77147 | 2101666.82906 | 37.751104762181 | -122.422796037611 | (37.751104762181, -122.422796037611) | 2 | 4 | 5 | 28859 | 19 | |||
1562 | 221496 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 2 | 3x3 | Permit Number 56125 | 6005594.03058 | 2105332.56679 | 37.7611585261709 | -122.423761214331 | (37.7611585261709, -122.423761214331) | 2 | 4 | 5 | 28859 | 19 | |
1567 | 240680 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005798.46813 | 2101640.54094 | 37.7510326203604 | -122.422791760451 | (37.7510326203604, -122.422791760451) | 2 | 4 | 5 | 28859 | 19 | ||
1947 | 240678 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005819.90053 | 2101295.53343 | 37.7500865182761 | -122.422693129992 | (37.7500865182761, -122.422693129992) | 2 | 4 | 5 | 28859 | 19 | ||
1991 | 110775 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:57:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
2093 | 221427 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.423275433821 | (37.7561368116793, -122.423275433821) | 2 | 4 | 5 | 28859 | 19 | ||
2332 | 91282 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
2506 | 240677 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005825.90541 | 2101167.17913 | 37.7497344256173 | -122.422663244623 | (37.7497344256173, -122.422663244623) | 2 | 4 | 5 | 28859 | 19 | ||
2731 | 91284 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
3021 | 221542 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005709.18006 | 2103278.94714 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | 2 | 4 | 5 | 28859 | 19 | |||
3115 | 221554 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005736.5559 | 2102753.56312 | 37.7540852287585 | -122.423084962814 | (37.7540852287585, -122.423084962814) | 2 | 4 | 5 | 28859 | 19 | ||
3217 | 221495 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 2 | 3x3 | Permit Number 56125 | 6005593.17627 | 2105367.35468 | 37.7612539972982 | -122.423766642643 | (37.7612539972982, -122.423766642643) | 2 | 4 | 5 | 28859 | 19 | |
5313 | 221425 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.423307021613 | (37.7563992716189, -122.423307021613) | 2 | 4 | 5 | 28859 | 19 | |||
5912 | 221553 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.11141 | 2102791.4847 | 37.7541892146839 | -122.423096111708 | (37.7541892146839, -122.423096111708) | 2 | 4 | 5 | 28859 | 19 | ||
6246 | 221421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005663.97142 | 2104121.3615 | 37.7578367884406 | -122.423433209975 | (37.7578367884406, -122.423433209975) | 2 | 4 | 5 | 28859 | 19 | ||
6280 | 221541 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | 2 | 4 | 5 | 28859 | 19 | |||
6810 | 243265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005691.43766 | 2103575.20205 | 37.7563387121803 | -122.42329939627 | (37.7563387121803, -122.42329939627) | 2 | 4 | 5 | 28859 | 19 | ||
7635 | 221501 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 2 | 3x3 | Permit Number 56125 | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | 2 | 4 | 5 | 28859 | 19 | |
7774 | 221416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005677.18728 | 2103848.76992 | 37.7570890615162 | -122.423368126034 | (37.7570890615162, -122.423368126034) | 2 | 4 | 5 | 28859 | 19 | ||
8268 | 221535 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005763.23809 | 2102308.0919 | 37.7528635735186 | -122.422961029952 | (37.7528635735186, -122.422961029952) | 2 | 4 | 5 | 28859 | 19 | ||
8628 | 221426 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005693.61577 | 2103548.60767 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | 2 | 4 | 5 | 28859 | 19 | ||
8919 | 91244 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 852x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:21:00 AM | 3 | 6005625 | 2104006 | 37.7575178330554 | -122.423559787953 | (37.7575178330554, -122.423559787953) | 2 | 4 | 5 | 28859 | 19 | |||
9030 | 221418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353201 | -122.423415847665 | (37.757466353201, -122.423415847665) | 2 | 4 | 5 | 28859 | 19 | ||
9125 | 240676 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005837.06183 | 2100943.32688 | 37.7491204080812 | -122.42260876008 | (37.7491204080812, -122.42260876008) | 2 | 4 | 5 | 28859 | 19 | ||
9435 | 221556 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.423062156895 | (37.753875475376, -122.423062156895) | 2 | 4 | 5 | 28859 | 19 | ||
10217 | 240681 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005788.04336 | 2101855.46027 | 37.751622151155 | -122.422843082969 | (37.751622151155, -122.422843082969) | 2 | 4 | 5 | 28859 | 19 | ||
10432 | 221544 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005705.62338 | 2103333.32509 | 37.7556753749283 | -122.423233144119 | (37.7556753749283, -122.423233144119) | 2 | 4 | 5 | 28859 | 19 | ||
11768 | 221543 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640819 | (37.7556029507207, -122.42322640819) | 2 | 4 | 5 | 28859 | 19 | |||
12356 | 152416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005631.99539 | 2104658.58909 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | 2 | 4 | 5 | 28859 | 19 | |||
13182 | 243321 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005700.91818 | 2103420.38667 | 37.7559141602344 | -122.423255604682 | (37.7559141602344, -122.423255604682) | 2 | 4 | 5 | 28859 | 19 | ||
13462 | 240682 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005773.46778 | 2102086.45101 | 37.7522555760398 | -122.422909902588 | (37.7522555760398, -122.422909902588) | 2 | 4 | 5 | 28859 | 19 | ||
13699 | 152413 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005625.07408 | 2104777.98262 | 37.7596375207611 | -122.423614417069 | (37.7596375207611, -122.423614417069) | 2 | 4 | 5 | 28859 | 19 | |||
13786 | 221552 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.10722 | 2102815.94179 | 37.7542563679477 | -122.423097864468 | (37.7542563679477, -122.423097864468) | 2 | 4 | 5 | 28859 | 19 | ||
14715 | 221546 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005723.96055 | 2103030.09242 | 37.7548438033068 | -122.423148175257 | (37.7548438033068, -122.423148175257) | 2 | 4 | 5 | 28859 | 19 | ||
15920 | 221557 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.423054419131 | (37.7537703032837, -122.423054419131) | 2 | 4 | 5 | 28859 | 19 | ||
17216 | 240679 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005802.65315 | 2101583.39169 | 37.7508759377955 | -122.422773227227 | (37.7508759377955, -122.422773227227) | 2 | 4 | 5 | 28859 | 19 | ||
18001 | 243333 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005703.0197 | 2103377.21002 | 37.7557957257993 | -122.423245267872 | (37.7557957257993, -122.423245267872) | 2 | 4 | 5 | 28859 | 19 | ||
18108 | 221419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005664.4202 | 2104015.71487 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | 2 | 4 | 5 | 28859 | 19 | ||
18986 | 221548 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005727.07279 | 2102965.97894 | 37.7546679382008 | -122.423132855309 | (37.7546679382008, -122.423132855309) | 2 | 4 | 5 | 28859 | 19 | ||
19567 | 109693 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
20283 | 221522 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6005804.6365 | 2101559.54048 | 37.7508105597627 | -122.42276467377 | (37.7508105597627, -122.42276467377) | 2 | 4 | 5 | 28859 | 19 | |||
21108 | 243241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005660.54217 | 2104179.64824 | 37.7579966366535 | -122.423449213415 | (37.7579966366535, -122.423449213415) | 2 | 4 | 5 | 28859 | 19 | |||
22666 | 221560 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898 | (37.7534669142699, -122.42159904898) | 2 | 4 | 5 | 28859 | 19 | |||
26192 | 109695 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
26579 | 221545 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005721.87722 | 2103062.70747 | 37.7549332390947 | -122.423157698184 | (37.7549332390947, -122.423157698184) | 2 | 4 | 5 | 28859 | 19 | |||
27720 | 221540 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005754.92272 | 2102467.80763 | 37.753301646771 | -122.423001136993 | (37.753301646771, -122.423001136993) | 2 | 4 | 5 | 28859 | 19 | |||
29061 | 221538 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | 2 | 4 | 5 | 28859 | 19 | |||
29249 | 221506 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.7560668947992 | -122.423269241105 | (37.7560668947992, -122.423269241105) | 2 | 4 | 5 | 28859 | 19 | |||
30628 | 110780 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:30:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
38198 | 91254 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 928x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.979082 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | 2 | 4 | 5 | 28859 | 19 | ||
38474 | 243239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005667.36599 | 2103954.71663 | 37.7573794121443 | -122.423409623453 | (37.7573794121443, -122.423409623453) | 2 | 4 | 5 | 28859 | 19 | |||
40155 | 221518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.422678186848 | (37.7499423731511, -122.422678186848) | 2 | 4 | 5 | 28859 | 19 | |||
40660 | 221528 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005788.73132 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | 2 | 4 | 5 | 28859 | 19 | |||
41721 | 110777 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:47:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
42106 | 221525 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005795.99168 | 2101720.64475 | 37.7512524272579 | -122.422806016491 | (37.7512524272579, -122.422806016491) | 2 | 4 | 5 | 28859 | 19 | |||
43244 | 91259 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 952x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | 2 | 4 | 5 | 28859 | 19 | ||
44242 | 221415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005678.5014 | 2103825.14435 | 37.7570242653802 | -122.423361901832 | (37.7570242653802, -122.423361901832) | 2 | 4 | 5 | 28859 | 19 | |||
44318 | 91245 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
45188 | 221530 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6005772.5167 | 2102115.11175 | 37.7523342181522 | -122.422915228372 | (37.7523342181522, -122.422915228372) | 2 | 4 | 5 | 28859 | 19 | |||
45689 | 221513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.422634853028 | (37.7494295931996, -122.422634853028) | 2 | 4 | 5 | 28859 | 19 | |||
46202 | 152421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | 2 | 4 | 5 | 28859 | 19 | |||
47649 | 91278 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
50929 | 91248 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 888x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | 2 | 4 | 5 | 28859 | 19 | |||
51627 | 91264 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 978X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.521495 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | 2 | 4 | 5 | 28859 | 19 | ||
52094 | 152420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005641.89151 | 2104501.69931 | 37.7588798608311 | -122.42353661134 | (37.7588798608311, -122.42353661134) | 2 | 4 | 5 | 28859 | 19 | |||
52768 | 110774 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
53870 | 110778 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
54019 | 91241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 |
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) );