trees
37 rows where Zip Codes = 28852 and qSpecies_id = 148
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
21517 | 27259 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
32018 | 14183 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 12 | 4X4 | Permit Number 769087 | 6005554.6579568 | 2109080.5883488 | 37.7714474783148 | -122.424163948162 | (37.7714474783148, -122.424163948162) | 7 | 2 | 5 | 28852 | 10 | |
32661 | 100407 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
32839 | 91205 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
33990 | 91343 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
35496 | 27675 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
39073 | 27258 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
39543 | 70859 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | Permit Number 767727 | 6006431.93006457 | 2110802.5343302 | 37.7762250224845 | -122.421251711265 | (37.7762250224845, -122.421251711265) | 7 | 9 | 11 | 28852 | 10 | |||
51107 | 91344 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
54616 | 13948 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1112X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1994 12:00:00 AM | 12 | 4x4 | 6008868.4803223 | 2112239.1730786 | 37.7803067555436 | -122.412924586563 | (37.7803067555436, -122.412924586563) | 7 | 2 | 9 | 28852 | 36 | ||
58660 | 13940 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1140X Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
58809 | 14170 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1776X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2015 10:09:00 AM | 3 | 4x4 | 6005777.896097 | 2109293.199395 | 37.7720438591777 | -122.423406872271 | (37.7720438591777, -122.423406872271) | 7 | 2 | 11 | 28852 | 10 | ||
59418 | 27255 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
64235 | 13870 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1000 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 8 | 4x4 | 6009621.3575962 | 2112944.5572428 | 37.7822858053101 | -122.410369845025 | (37.7822858053101, -122.410369845025) | 14 | 2 | 9 | 28852 | 36 | ||
75983 | 91335 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
77944 | 27674 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
81270 | 22592 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 785X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/2002 12:00:00 AM | 3 | 4X4 | 6006155.3095005 | 2112777.9901286 | 37.7816335448796 | -122.422349009875 | (37.7816335448796, -122.422349009875) | 7 | 9 | 11 | 28852 | 41 | ||
84052 | 13946 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1108 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/08/1999 12:00:00 AM | 12 | 4x4 | 6008893.4024674 | 2112262.9816205 | 37.7803735270406 | -122.412840052753 | (37.7803735270406, -122.412840052753) | 7 | 2 | 9 | 28852 | 36 | ||
87123 | 91336 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
87629 | 27679 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
93141 | 23203 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 590 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1999 12:00:00 AM | 8 | 3x3 | 6006785.52098 | 2112480.30357 | 37.7808516993941 | -122.420147639969 | (37.7808516993941, -122.420147639969) | 7 | 9 | 9 | 28852 | 36 | ||
93447 | 27256 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 660X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
100838 | 14187 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 18 | 4X4 | Permit Number 769087 | 6005518.4692831 | 2109046.2188948 | 37.7713510647017 | -122.424286681889 | (37.7713510647017, -122.424286681889) | 7 | 2 | 5 | 28852 | 10 | |
105085 | 91204 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
106090 | 13837 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 972 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6009828.8708825 | 2113156.6502082 | 37.7828797927495 | -122.409666913005 | (37.7828797927495, -122.409666913005) | 14 | 2 | 9 | 28852 | 36 | ||
122483 | 14626 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 410X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/05/2001 12:00:00 AM | 20 | 3X3 | 6007165.24508 | 2112272.29684 | 37.7803019512551 | -122.418819229453 | (37.7803019512551, -122.418819229453) | 7 | 9 | 9 | 28852 | 36 | ||
126355 | 27676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
127174 | 27257 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 660X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2004 12:00:00 AM | 3 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | ||
138619 | 100408 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
139425 | 27252 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
149234 | 27678 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
155330 | 14031 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1244 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6008141.7716697 | 2111544.9362715 | 37.7783597285455 | -122.415389454094 | (37.7783597285455, -122.415389454094) | 7 | 2 | 9 | 28852 | 36 | ||
159666 | 27254 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 | |||
162970 | 14117 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1572X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 12:52:00 PM | 3 | 4x4 | 6006735.3160639 | 2110201.3257307 | 37.7745913473524 | -122.420159536302 | (37.7745913473524, -122.420159536302) | 7 | 2 | 11 | 28852 | 10 | ||
163970 | 27677 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
177115 | 27253 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 620X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.420326195624 | (37.7813170997428, -122.420326195624) | 7 | 9 | 9 | 28852 | 36 |
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) );