trees
35 rows where Supervisor Districts = 2 and qSpecies_id = 53 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14899 | 110708 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
31383 | 110696 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
33102 | 110710 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
37914 | 110712 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
38950 | 93145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
42506 | 121635 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560 | 2111978 | 37.7786607112968 | -122.469323657797 | (37.7786607112968, -122.469323657797) | 11 | 6 | 2 | 54 | 11 | ||
58136 | 106999 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | 15 | 6 | 2 | 29492 | 16 | |||||
61629 | 117600 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 565 39TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983700 | 2111975 | 37.7781364952795 | -122.499973114435 | (37.7781364952795, -122.499973114435) | 11 | 6 | 2 | 55 | 26 | |||
78948 | 9076 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 5618 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | 11 | 6 | 2 | 55 | 26 | |||
79156 | 105290 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 330 11TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 5992515.1 | 2113228.4 | 37.7820913739714 | -122.469570031425 | (37.7820913739714, -122.469570031425) | 11 | 6 | 2 | 54 | 11 | ||||
87883 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | 5992930 | 2110298 | 37.7740692588728 | -122.467921468059 | (37.7740692588728, -122.467921468059) | 11 | 6 | 2 | 54 | 11 | ||||
94512 | 9071 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 5600 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1990 12:00:00 AM | 12 | 3X3 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | 11 | 6 | 2 | 55 | 26 | ||
97500 | 1685 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 452X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994164.03145 | 2111506.7878 | 37.7774594509207 | -122.463740525584 | (37.7774594509207, -122.463740525584) | 11 | 6 | 2 | 54 | 11 | |||
97854 | 117647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 86 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5996396 | 2111643 | 37.7779618147655 | -122.456029304513 | (37.7779618147655, -122.456029304513) | 11 | 6 | 2 | 54 | 16 | |||
100462 | 110704 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
105276 | 9077 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 5618 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | 11 | 6 | 2 | 55 | 26 | |||
105841 | 93144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2016 12:00:00 AM | 3 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||
112841 | 1679 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994545.07613 | 2111468.1594 | 37.7773753373943 | -122.462419573309 | (37.7773753373943, -122.462419573309) | 11 | 6 | 2 | 54 | 11 | |||
121596 | 110698 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996770.5 | 2111189.3 | 37.7767375616272 | -122.454700997037 | (37.7767375616272, -122.454700997037) | 15 | 6 | 2 | 54 | 16 | ||||
127826 | 117648 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 86 ROSSI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5996396 | 2111643 | 37.7779618147655 | -122.456029304513 | (37.7779618147655, -122.456029304513) | 11 | 6 | 2 | 54 | 16 | |||
129746 | 117649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 82 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5996392 | 2111672 | 37.778041211542 | -122.456045238979 | (37.778041211542, -122.456045238979) | 11 | 6 | 2 | 54 | 16 | |||
144627 | 9079 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 5625 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5989525.4329 | 2112589.82108 | 37.7801647748824 | -122.479866062567 | (37.7801647748824, -122.479866062567) | 11 | 6 | 2 | 55 | 26 | |||
146111 | 111378 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
149202 | 93146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
162441 | 26666 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.7862781034857 | -122.470404314824 | (37.7862781034857, -122.470404314824) | 11 | 6 | 2 | 54 | 11 | |||
169047 | 9070 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1990 12:00:00 AM | 12 | 3X3 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | 11 | 6 | 2 | 55 | 26 | ||
169641 | 12630 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 841 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5992831.38337 | 2114795.44702 | 37.7864123300728 | -122.468589897945 | (37.7864123300728, -122.468589897945) | 11 | 6 | 2 | 54 | 11 | |||
178358 | 110702 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
179624 | 110706 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2999X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
182236 | 117650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 79 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5996337 | 2111626 | 37.7779117506286 | -122.456232175702 | (37.7779117506286, -122.456232175702) | 11 | 6 | 2 | 54 | 16 | |||
49890 | 52592 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | 11 | 6 | 2 | 55 | 26 | ||||
46064 | 106808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.448796407891 | (37.7757692329232, -122.448796407891) | 15 | 6 | 2 | 29492 | 16 | |||
30376 | 94524 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3322 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774668 | 5988381 | 2111924 | 37.7782700631784 | -122.483776297443 | (37.7782700631784, -122.483776297443) | 11 | 6 | 2 | 55 | 26 | |||
8496 | 115992 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.479162248453 | (37.7795296278249, -122.479162248453) | 11 | 6 | 2 | 55 | 26 | ||
116714 | 59226 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | 11 | 6 | 2 | 54 | 11 |
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) );