trees
48 rows where Zip Codes = 54 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11487 | 260838 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
12511 | 260840 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
14328 | 104230 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.448704479556 | (37.787869332154, -122.448704479556) | 13 | 6 | 1 | 54 | 31 | ||||
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 | ||||
23488 | 1442 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||||
38373 | 52226 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 423 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2005 12:00:00 AM | Permit Number 48405 | 5997634.34727934 | 2115023.86499621 | 37.7873157808513 | -122.451989424725 | (37.7873157808513, -122.451989424725) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
49311 | 8762 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
57729 | 16813 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2097X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999009.37837 | 2112716.355 | 37.7810586242256 | -122.447066002739 | (37.7810586242256, -122.447066002739) | 15 | 5 | 1 | 54 | 16 | |||
62457 | 96407 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995910 | 2115869 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | 11 | 6 | 1 | 54 | 31 | |||||
69533 | 8763 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||||
79887 | 16728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
80144 | 96411 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2012 12:00:00 AM | Permit Number 768662 | 5995910 | 2115869 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | 11 | 6 | 1 | 54 | 31 | |||
85440 | 96410 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767718 | 5995910 | 2115869 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||||
90878 | 106915 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772728 | 5995876.04542 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | 11 | 6 | 1 | 54 | 31 | ||||
91802 | 8767 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||||
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 | |||
105995 | 96408 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995910 | 2115869 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | 11 | 6 | 1 | 54 | 31 | |||||
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 | |||
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 | ||
119477 | 106916 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3832 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | 5995876.04542 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | |||||
157941 | 8764 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
161646 | 8766 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | |||
171777 | 96409 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995910 | 2115869 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | 11 | 6 | 1 | 54 | 31 | |||||
176898 | 8765 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
177091 | 108561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 141 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995170 | 2114629.2 | 37.7860906748156 | -122.460486880145 | (37.7860906748156, -122.460486880145) | 11 | 6 | 1 | 54 | 11 | ||||
177292 | 16729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
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 | |||
184073 | 8768 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
193266 | 97278 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 60 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768156 | 5995934.7 | 2114107.9 | 37.7847032866401 | -122.457803503646 | (37.7847032866401, -122.457803503646) | 11 | 6 | 1 | 54 | 31 |
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) );