trees
35 rows where Fire Prevention Districts = 5 and qSpecies_id = 54 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
89354 | 143480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010907.473 | 2116280.5305 | 37.7915176085666 | -122.406155537422 | (37.7915176085666, -122.406155537422) | 5 | 1 | 10 | 28857 | 6 | |||
55085 | 143481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010890.3641 | 2116278.8196 | 37.7915119538645 | -122.40621461367 | (37.7915119538645, -122.40621461367) | 5 | 1 | 10 | 28857 | 6 | |||
32385 | 143482 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010529.9358 | 2116279.9602 | 37.7914949183295 | -122.407461776619 | (37.7914949183295, -122.407461776619) | 5 | 1 | 10 | 28857 | 21 | |||
7836 | 72023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.407543551006 | (37.7919886256319, -122.407543551006) | 5 | 1 | 10 | 28857 | 21 | |||
30141 | 143475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010503.0699 | 2116501.51 | 37.7921017369748 | -122.407570359871 | (37.7921017369748, -122.407570359871) | 5 | 1 | 10 | 28857 | 21 | |||
168911 | 142600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008394.1949 | 2120748.9012 | 37.803645748305 | -122.415167905628 | (37.803645748305, -122.415167905628) | 5 | 1 | 10 | 308 | 32 | |||
114293 | 142599 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008384.0855 | 2120756.6777 | 37.8036665324855 | -122.415203440632 | (37.8036665324855, -122.415203440632) | 5 | 1 | 10 | 308 | 32 | |||
153905 | 142598 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008376.309 | 2120765.2318 | 37.8036895828586 | -122.415230957587 | (37.8036895828586, -122.415230957587) | 5 | 1 | 10 | 308 | 32 | |||
127703 | 142597 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008368.5325 | 2120773.0083 | 37.8037104981311 | -122.41525841948 | (37.8037104981311, -122.41525841948) | 5 | 1 | 10 | 308 | 32 | |||
31104 | 142596 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | 5 | 1 | 10 | 308 | 32 | |||
139954 | 4720 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | 5 | 1 | 10 | 308 | 23 | |||
120153 | 142993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.8037542892016 | -122.415324162836 | (37.8037542892016, -122.415324162836) | 5 | 1 | 10 | 308 | 32 | |||
94505 | 142595 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.8037793437918 | -122.415359808453 | (37.8037793437918, -122.415359808453) | 5 | 1 | 10 | 308 | 32 | |||
60133 | 4721 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | 5 | 1 | 10 | 308 | 23 | |||
139018 | 142594 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008329.6499 | 2120808.0026 | 37.8038043983711 | -122.415395454094 | (37.8038043983711, -122.415395454094) | 5 | 1 | 10 | 308 | 32 | |||
82332 | 4722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.8040653448727 | -122.415444338519 | (37.8040653448727, -122.415444338519) | 5 | 1 | 10 | 308 | 23 | |||
50942 | 142593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | 5 | 1 | 10 | 308 | 32 | |||
109992 | 142604 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6008306.3204 | 2120712.3516 | 37.8035404535195 | -122.415469411535 | (37.8035404535195, -122.415469411535) | 5 | 1 | 10 | 308 | 32 | |||
108538 | 142592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | 5 | 1 | 10 | 308 | 32 | |||
81395 | 4723 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.8041177920118 | -122.415523078458 | (37.8041177920118, -122.415523078458) | 5 | 1 | 10 | 308 | 23 | |||
111305 | 142591 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008291.5451 | 2120841.4416 | 37.8038940717069 | -122.41552968724 | (37.8038940717069, -122.41552968724) | 5 | 1 | 10 | 308 | 32 | |||
47497 | 142605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.415550034395 | (37.8035348717489, -122.415550034395) | 5 | 1 | 10 | 308 | 32 | |||
150356 | 28073 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1075 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008262.9463 | 2120869.8064 | 37.8039703467655 | -122.415630664984 | (37.8039703467655, -122.415630664984) | 5 | 1 | 10 | 308 | 32 | |||
4593 | 4724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.415647128831 | (37.8042017393393, -122.415647128831) | 5 | 1 | 10 | 308 | 23 | |||
156904 | 4726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6008251.3021 | 2120879.612 | 37.8039966159278 | -122.415671655323 | (37.8039966159278, -122.415671655323) | 5 | 1 | 10 | 308 | 32 | ||||
48457 | 4725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | 5 | 1 | 10 | 308 | 23 | |||
6549 | 142706 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 567 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008189.6261 | 2121340.372 | 37.8052582795068 | -122.415917737693 | (37.8052582795068, -122.415917737693) | 5 | 1 | 10 | 308 | 23 | |||
46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
147046 | 99232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | 5 | 1 | 10 | 308 | 32 | |||
172700 | 99231 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.8044892892651 | -122.416393331612 | (37.8044892892651, -122.416393331612) | 5 | 1 | 10 | 308 | 32 | |||
176662 | 99230 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | 5 | 1 | 10 | 308 | 32 | |||
109841 | 99229 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.8045463921415 | -122.416476410342 | (37.8045463921415, -122.416476410342) | 5 | 1 | 10 | 308 | 32 | |||
96661 | 99228 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | 5 | 1 | 10 | 308 | 32 | |||
192594 | 99227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | 5 | 1 | 10 | 308 | 32 | |||
88548 | 99210 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | 5 | 1 | 10 | 308 | 32 |
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) );