trees
50 rows where Zip Codes = 64 and qSpecies_id = 95 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6249 | 211394 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 7 | Width 0ft | 5991385.47593 | 2094405.95622 | 37.7303445458499 | -122.472105586627 | (37.7303445458499, -122.472105586627) | 9 | 8 | 4 | 64 | 40 | |||
11059 | 211396 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 7 | Width 0ft | 5991320.25705 | 2093401.75426 | 37.7275834841643 | -122.47225788142 | (37.7275834841643, -122.47225788142) | 9 | 8 | 4 | 64 | 40 | |||
20008 | 211390 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2650 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990847.61184 | 2095069.65552 | 37.7321357561478 | -122.474013443484 | (37.7321357561478, -122.474013443484) | 1 | 8 | 4 | 64 | 40 | |||
31479 | 211369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 581 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994016.09207 | 2090360.38105 | 37.7193882591349 | -122.46271788662 | (37.7193882591349, -122.46271788662) | 9 | 8 | 6 | 64 | 24 | |||
36435 | 1230 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3601X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X4 | 5993445.41864 | 2087516.92091 | 37.7115479146888 | -122.464484128155 | (37.7115479146888, -122.464484128155) | 9 | 8 | 4 | 64 | 24 | |||
38659 | 211381 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2611 Ocean Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5990943.4517 | 2094937.26304 | 37.7317777909083 | -122.47367245292 | (37.7317777909083, -122.47367245292) | 1 | 8 | 4 | 64 | 40 | |||
38776 | 224 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2956 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X4 | 5990611.41299 | 2095529.2809 | 37.7333840861908 | -122.474863563627 | (37.7333840861908, -122.474863563627) | 1 | 8 | 4 | 64 | 40 | |||
40465 | 211384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991108.5892 | 2094839.96583 | 37.7315201998923 | -122.473094451455 | (37.7315201998923, -122.473094451455) | 1 | 8 | 4 | 64 | 40 | |||
41586 | 29974 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991354.73078 | 2093700.79084 | 37.7284065590072 | -122.47216049472 | (37.7284065590072, -122.47216049472) | 9 | 8 | 4 | 64 | 40 | ||
45357 | 211399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 1 | Width 0ft | 5991315.94371 | 2093311.6752 | 37.7273358999139 | -122.472266228913 | (37.7273358999139, -122.472266228913) | 9 | 8 | 4 | 64 | 40 | |||
49616 | 211383 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Ocean Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991035.59331 | 2094881.14512 | 37.7316290412296 | -122.473349812154 | (37.7316290412296, -122.473349812154) | 1 | 8 | 4 | 64 | 40 | |||
55849 | 48560 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
57786 | 48561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
58810 | 211398 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 1 | Width 0ft | 5991312.42459 | 2093316.55821 | 37.7273491037745 | -122.472278750188 | (37.7273491037745, -122.472278750188) | 9 | 8 | 4 | 64 | 40 | |||
59273 | 211376 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 412 Bright St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5993789.39485 | 2089870.81685 | 37.7180309744407 | -122.463465979579 | (37.7180309744407, -122.463465979579) | 9 | 8 | 6 | 64 | 24 | |||
60869 | 211378 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2666 Ocean Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990751.88782 | 2095123.64703 | 37.7322784578663 | -122.474348317746 | (37.7322784578663, -122.474348317746) | 1 | 8 | 4 | 64 | 40 | |||
63450 | 337 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3590X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
67313 | 211397 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 1 | Width 0ft | 5991314.17721 | 2093323.33427 | 37.7273678105764 | -122.47227318518 | (37.7273678105764, -122.47227318518) | 9 | 8 | 4 | 64 | 40 | |||
72248 | 211386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2525 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991180.22123 | 2094794.23691 | 37.7313987869056 | -122.472843474954 | (37.7313987869056, -122.472843474954) | 1 | 8 | 4 | 64 | 40 | |||
79568 | 211403 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 79 | : | Tree | Private 2 | 8 | Width 0ft | 5991310.66236 | 2093194.76512 | 37.7270145883399 | -122.472275967673 | (37.7270145883399, -122.472275967673) | 9 | 8 | 4 | 64 | 40 | |||
83106 | 178380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3353 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990552.58641 | 2094153.60433 | 37.7296034172653 | -122.474966557576 | (37.7296034172653, -122.474966557576) | 1 | 8 | 4 | 64 | 14 | |||
84089 | 211400 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 59 | : | Tree | Private 2 | 1 | Width 0ft | 5991311.81969 | 2093306.95297 | 37.7273226951736 | -122.472280141417 | (37.7273226951736, -122.472280141417) | 9 | 8 | 4 | 64 | 40 | |||
85849 | 211395 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 33 | : | Tree | Private 2 | 4 | Width 0ft | 5991333.87103 | 2093589.42077 | 37.7280995574272 | -122.472224492267 | (37.7280995574272, -122.472224492267) | 9 | 8 | 4 | 64 | 40 | |||
87867 | 11879 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 17 | 20 | 5991400.98667 | 2094604.94103 | 37.7308918058105 | -122.472066462495 | (37.7308918058105, -122.472066462495) | 9 | 8 | 4 | 64 | 40 | |||
94956 | 11661 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 700X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991304.37203 | 2093039.68801 | 37.7265884212004 | -122.472286413287 | (37.7265884212004, -122.472286413287) | 9 | 8 | 4 | 64 | 40 | ||
99035 | 29957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991400.4743 | 2094594.98501 | 37.7308644394281 | -122.472067508419 | (37.7308644394281, -122.472067508419) | 9 | 8 | 4 | 64 | 40 | |||
99271 | 211368 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 581 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994015.82193 | 2090388.05 | 37.7194642158701 | -122.46272082651 | (37.7194642158701, -122.46272082651) | 9 | 8 | 6 | 64 | 24 | |||
103335 | 50395 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 127 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 1 | Permit Number 47046 | 5987033.45591 | 2095011.41616 | 37.7317541720083 | -122.487195376871 | (37.7317541720083, -122.487195376871) | 1 | 8 | 4 | 64 | 35 | |
106772 | 211392 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 11 | : | Tree | Private 2 | 24 | Width 0ft | 5991388.85233 | 2094538.65756 | 37.7307091058353 | -122.472103582919 | (37.7307091058353, -122.472103582919) | 9 | 8 | 4 | 64 | 40 | |||
110987 | 211387 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2523 Ocean Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991235.72869 | 2094765.49267 | 37.7313230756794 | -122.472649482185 | (37.7313230756794, -122.472649482185) | 1 | 8 | 4 | 64 | 40 | |||
112810 | 49950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1680 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46706 | 5985923.93162312 | 2095914.5816821 | 37.7341692652739 | -122.491097616053 | (37.7341692652739, -122.491097616053) | 1 | 8 | 3 | 64 | 35 | ||
113999 | 211385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5991126.50204 | 2094829.45786 | 37.731492384761 | -122.473031757922 | (37.731492384761, -122.473031757922) | 1 | 8 | 4 | 64 | 40 | |||
115888 | 30053 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991402.00396 | 2094617.05729 | 37.7309251328883 | -122.472063828393 | (37.7309251328883, -122.472063828393) | 9 | 8 | 4 | 64 | 40 | |||
116315 | 417 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 5990888.82465 | 2090075.47964 | 37.7184253822074 | -122.473506810731 | (37.7184253822074, -122.473506810731) | 9 | 8 | 4 | 64 | 40 | |||
116711 | 211401 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 62 | : | Tree | Private 2 | 12 | Width 0ft | 5991312.10074 | 2093282.10012 | 37.7272544717134 | -122.472277358928 | (37.7272544717134, -122.472277358928) | 9 | 8 | 4 | 64 | 40 | |||
121279 | 211380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2645 Ocean Ave | 3 | : | Tree | Private 2 | 9 | Width 3ft | 5990864.72749 | 2094979.44437 | 37.731889050535 | -122.473947692236 | (37.731889050535, -122.473947692236) | 1 | 8 | 4 | 64 | 40 | |||
126519 | 211379 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2661 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5990752.61196 | 2095053.16145 | 37.7320849642463 | -122.474340672589 | (37.7320849642463, -122.474340672589) | 1 | 8 | 4 | 64 | 40 | |||
127092 | 211374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 446 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993509.98372 | 2088840.25773 | 37.7151852037961 | -122.464356993699 | (37.7151852037961, -122.464356993699) | 9 | 8 | 6 | 64 | 24 | |||
129924 | 211388 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2528 Ocean Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991260.83689 | 2094823.54256 | 37.7314839194419 | -122.472566910044 | (37.7314839194419, -122.472566910044) | 1 | 8 | 4 | 64 | 40 | |||
137150 | 211393 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 20 | Width 0ft | 5991388.09058 | 2094530.01431 | 37.7306853295574 | -122.472105586615 | (37.7306853295574, -122.472105586615) | 9 | 8 | 4 | 64 | 40 | |||
140380 | 211402 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 77 | : | Tree | Private 2 | 10 | Width 0ft | 5991311.70332 | 2093205.96444 | 37.7270453991248 | -122.472273185163 | (37.7270453991248, -122.472273185163) | 9 | 8 | 4 | 64 | 40 | |||
140833 | 416 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5990882.28531 | 2090084.77659 | 37.7184505306428 | -122.473530092056 | (37.7184505306428, -122.473530092056) | 9 | 8 | 4 | 64 | 40 | ||||
148266 | 211382 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991018.58342 | 2094892.51485 | 37.7316592746545 | -122.473409447106 | (37.7316592746545, -122.473409447106) | 1 | 8 | 4 | 64 | 40 | |||
153763 | 211391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 7 | : | Tree | Private 2 | 16 | Width 0ft | 5991391.10159 | 2094562.85542 | 37.7307756772501 | -122.472097570057 | (37.7307756772501, -122.472097570057) | 9 | 8 | 4 | 64 | 40 | |||
154768 | 11640 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 5991362.1134613 | 2093824.2614448 | 37.7287460056648 | -122.472143968924 | (37.7287460056648, -122.472143968924) | 9 | 8 | 4 | 64 | 40 | |||
166495 | 29973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991350.6997 | 2093700.47523 | 37.7284054591375 | -122.472174407226 | (37.7284054591375, -122.472174407226) | 9 | 8 | 4 | 64 | 40 | ||
166573 | 211377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 438 Shields St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992783.55943 | 2089868.41176 | 37.71796636713 | -122.466942511301 | (37.71796636713, -122.466942511301) | 9 | 8 | 6 | 64 | 24 | |||
166965 | 272 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3201X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | |||
168839 | 211389 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2650 Ocean Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5990873.32433 | 2095051.49544 | 37.7320873825274 | -122.473923226178 | (37.7320873825274, -122.473923226178) | 1 | 8 | 4 | 64 | 40 | |||
177450 | 211375 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 462 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993511.66198 | 2088947.80239 | 37.7154805924354 | -122.464358996492 | (37.7154805924354, -122.464358996492) | 9 | 8 | 6 | 64 | 24 |
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) );