trees
41 rows where Fire Prevention Districts = 2 and qSpecies_id = 54
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
23530 | 245383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.424260783275 | (37.7369948294896, -122.424260783275) | 2 | 7 | 5 | 28859 | 2 | |||
27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
45788 | 113409 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003916 | 2099815 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | 2 | 7 | 5 | 63 | 22 | ||||
48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 2 | 7 | 7 | 28859 | 2 | |||
56271 | 514 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.7529262972422 | -122.407932936557 | (37.7529262972422, -122.407932936557) | 2 | 4 | 7 | 28859 | 19 | |||
61639 | 498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770282 | (37.7529579449469, -122.40743770282) | 2 | 4 | 7 | 28859 | 19 | |||
67867 | 513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.7529230716135 | -122.407992859485 | (37.7529230716135, -122.407992859485) | 2 | 4 | 7 | 28859 | 19 | |||
79122 | 533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009680.0053 | 2102218.3979 | 37.7528375279845 | -122.409409734124 | (37.7528375279845, -122.409409734124) | 2 | 4 | 7 | 28859 | 19 | |||
89324 | 545 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.409830929661 | (37.7528128183786, -122.409830929661) | 2 | 4 | 7 | 28859 | 19 | |||
92667 | 37059 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.7459305281666 | -122.429203495744 | (37.7459305281666, -122.429203495744) | 2 | 7 | 5 | 63 | 22 | ||
105187 | 547 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2889 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009603.6887 | 2102171.1765 | 37.7527035922626 | -122.409670319384 | (37.7527035922626, -122.409670319384) | 2 | 4 | 7 | 28859 | 19 | |||
105481 | 549 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.409916012434 | (37.7526901583127, -122.409916012434) | 2 | 4 | 7 | 28859 | 19 | |||
110511 | 542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.409675492792 | (37.7528202149244, -122.409675492792) | 2 | 4 | 7 | 28859 | 19 | |||
110627 | 520 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2809 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6009957.8393 | 2102189.816 | 37.752774611474 | -122.408446912653 | (37.752774611474, -122.408446912653) | 2 | 4 | 7 | 28859 | 19 | |||
116079 | 15627 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005560.95 | 2097781.3943 | 37.7404228796109 | -122.423338814191 | (37.7404228796109, -122.423338814191) | 2 | 7 | 7 | 28859 | 2 | |||
130276 | 245378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005581.5521 | 2097815.7311 | 37.7405183234498 | -122.423270020371 | (37.7405183234498, -122.423270020371) | 2 | 7 | 7 | 28859 | 2 | |||
134819 | 113410 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 401x DUNCAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003916 | 2099815 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | 2 | 7 | 5 | 63 | 22 | ||||
137337 | 501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2754 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6010215.9248 | 2102247.7419 | 37.7529481129231 | -122.407558485659 | (37.7529481129231, -122.407558485659) | 2 | 4 | 7 | 28859 | 19 | |||
142773 | 37061 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.7459305281666 | -122.429203495744 | (37.7459305281666, -122.429203495744) | 2 | 7 | 5 | 63 | 22 | |
142974 | 245382 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005277.267 | 2096556.8057 | 37.7370444205252 | -122.424232607489 | (37.7370444205252, -122.424232607489) | 2 | 7 | 5 | 28859 | 2 | |||
145196 | 113408 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003890 | 2099760 | 37.7457612277667 | -122.429257354108 | (37.7457612277667, -122.429257354108) | 2 | 7 | 5 | 63 | 22 | ||||
146796 | 15628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.7402806235852 | -122.423438788897 | (37.7402806235852, -122.423438788897) | 2 | 7 | 7 | 28859 | 2 | |||
172312 | 527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | 2 | 4 | 7 | 28859 | 19 | |||
176892 | 544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009585.3031 | 2102212.479 | 37.7528159694172 | -122.409736815429 | (37.7528159694172, -122.409736815429) | 2 | 4 | 7 | 28859 | 19 | |||
178861 | 37062 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.7459305281666 | -122.429203495744 | (37.7459305281666, -122.429203495744) | 2 | 7 | 5 | 63 | 22 | ||
184065 | 15445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | 2 | 4 | 7 | 28859 | 19 | |||
187119 | 524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.7528785688198 | -122.408682823354 | (37.7528785688198, -122.408682823354) | 2 | 4 | 7 | 28859 | 19 | |||
189533 | 532 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | 2 | 4 | 7 | 28859 | 19 |
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) );