trees
339 rows where qSpecies_id = 30 sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
112972 | 88538 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
2914 | 203291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 11 Jules Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994415.48252 | 2089998.39973 | 37.7184173393668 | -122.461311125716 | (37.7184173393668, -122.461311125716) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |
20296 | 43734 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 777 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43371 | 5994281.26699369 | 2089905.22565848 | 37.7181537802459 | -122.461768297306 | (37.7181537802459, -122.461768297306) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
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 | |||
34578 | 203292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 10 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994458.02189 | 2089982.35817 | 37.7183757412389 | -122.461162923744 | (37.7183757412389, -122.461162923744) | 9 | 8 | 6 | 28861 | 24 | |||
48008 | 43725 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 759 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43364 | 5994445.58077229 | 2089904.10562801 | 37.7181601624587 | -122.461200257981 | (37.7181601624587, -122.461200257981) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
62006 | 43724 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 759 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43364 | 5994445.58077229 | 2089904.10562801 | 37.7181601624587 | -122.461200257981 | (37.7181601624587, -122.461200257981) | 9 | 8 | 6 | 28861 | 24 | ||
62222 | 54118 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | ||
68150 | 221564 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001316.91777 | 2102341.73596 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | 2 | 4 | 5 | 28862 | 22 | |||
73744 | 221562 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.28805 | 2102498.92878 | 37.75341002046 | -122.421598049829 | (37.75341002046, -122.421598049829) | 2 | 4 | 5 | 28859 | 19 | |||
77452 | 221561 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
83337 | 221569 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | 2 | 4 | 5 | 28862 | 3 | |||
92341 | 221565 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001328.91667 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | 2 | 4 | 5 | 28862 | 22 | |||
94070 | 203290 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 11 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994415.40381 | 2090011.14136 | 37.7184523203103 | -122.461312320932 | (37.7184523203103, -122.461312320932) | 9 | 8 | 6 | 28861 | 24 | |||
96242 | 221567 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | 2 | 4 | 5 | 28862 | 22 | |||
124564 | 257893 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 23 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003365 | 2086282 | 37.7087239233851 | -122.430111404197 | (37.7087239233851, -122.430111404197) | 9 | 7 | 6 | 28861 | 5 | ||||
125308 | 43729 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 763 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43366 | 5994409.95328954 | 2089904.45905166 | 37.7181590824666 | -122.461323431638 | (37.7181590824666, -122.461323431638) | 9 | 8 | 6 | 28861 | 24 | ||
131495 | 56924 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 140 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 3 | Permit Number 14167 | 6002240.5096 | 2093994.70553 | 37.7298375431559 | -122.434548888919 | (37.7298375431559, -122.434548888919) | 9 | 7 | 5 | 28861 | 25 | ||
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 | |||
138398 | 43727 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
141785 | 43728 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
145933 | 221566 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001342.88204 | 2102344.46852 | 37.7527130350975 | -122.438250016433 | (37.7527130350975, -122.438250016433) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
156067 | 221563 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.7527030580007 | -122.438378727412 | (37.7527030580007, -122.438378727412) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
176610 | 43726 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
178245 | 56594 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 533 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768959 | 6003224 | 2096098 | 37.7356684939052 | -122.431298930259 | (37.7356684939052, -122.431298930259) | 2 | 7 | 5 | 63 | 7 | |
180105 | 221568 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
193332 | 66265 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 4020 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 3 | 6x9 | Permit Number 29370 | 6003740.3803829 | 2100725.5739603 | 37.7484039979455 | -122.429843577344 | (37.7484039979455, -122.429843577344) | 2 | 4 | 5 | 28862 | 22 | |
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 | ||||
24279 | 175079 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1104x Alemany Blvd | 1 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6003837.73065 | 2094453.46286 | 37.7311877286109 | -122.429059809376 | (37.7311877286109, -122.429059809376) | 9 | 7 | 6 | 28861 | 25 | |||
79544 | 91239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Hanging Pot | Tree | DPW 1 | 11/20/1989 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
1516 | 221470 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:30:00 AM | 1 | 3x3 | Permit Number 56125 | 6005530.44166 | 2106496.00345 | 37.7643494583795 | -122.424063881144 | (37.7643494583795, -122.424063881144) | 8 | 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 | ||
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 | |||||||||||||
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 | |
3421 | 221449 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005469.95975 | 2107527.18332 | 37.767177417921 | -122.424346419355 | (37.767177417921, -122.424346419355) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||||||||||||
5169 | 221481 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005557.32843 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | 8 | 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 | |||
5824 | 221435 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.7689082693198 | -122.424501499347 | (37.7689082693198, -122.424501499347) | 8 | 4 | 5 | 28853 | 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 | ||
6153 | 221430 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | 8 | 4 | 5 | 28853 | 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 | ||
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 | |||||||||||||
8773 | 262076 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800X Alemany Blvd | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
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 | |||||||||||||
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 | ||
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 | |||||||||||||
10894 | 221460 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:41:00 AM | 2 | 3x3 | Permit Number 56125 | 6005499.89777 | 2107004.0817 | 37.7657427960049 | -122.424205661071 | (37.7657427960049, -122.424205661071) | 8 | 4 | 5 | 28853 | 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 | |||
12077 | 221469 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:33:00 AM | 1 | 3x3 | 6005528.17729 | 2106528.83552 | 37.7644394796106 | -122.424074047995 | (37.7644394796106, -122.424074047995) | 8 | 4 | 5 | 28859 | 19 | ||
12213 | 221456 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 2 | 3x3 | Permit Number 56125 | 6005491.36744 | 2107155.48275 | 37.7661580255906 | -122.424245934501 | (37.7661580255906, -122.424245934501) | 8 | 4 | 5 | 28853 | 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 | |||
12484 | 221478 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:18:00 AM | 1 | 3x3 | Permit Number 56125 | 6005544.06849 | 2106215.1538 | 37.7635790811436 | -122.423996776447 | (37.7635790811436, -122.423996776447) | 8 | 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 | ||
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 | |||||||||||||
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 | ||
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 | |||||||||||||
15879 | 221486 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | 8 | 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 | ||
16547 | 221467 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:14:00 AM | 1 | 3x3 | Permit Number 56125 | 6005513.55753 | 2106751.9184 | 37.765051186799 | -122.424140480012 | (37.765051186799, -122.424140480012) | 8 | 4 | 5 | 28853 | 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 |
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) );