trees
36 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 30
This data as json, CSV (advanced)
These facets timed out: qSiteInfo
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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) );