trees
41 rows where Fire Prevention Districts = 2 and qSpecies_id = 54 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
5046 | 245409 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | 2 | 4 | 7 | 28859 | 19 | |||
17488 | 245410 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.7529335917078 | -122.407871614204 | (37.7529335917078, -122.407871614204) | 2 | 4 | 7 | 28859 | 19 | |||
18387 | 245411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | 2 | 4 | 7 | 28859 | 19 | |||
831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
3102 | 245419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | 2 | 4 | 7 | 28859 | 19 | |||
14249 | 245420 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | 2 | 4 | 7 | 28859 | 19 | |||
1544 | 245421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443998 | -122.409836678395 | (37.752691443998, -122.409836678395) | 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 | ||
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 | |
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 | ||
11090 | 38646 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 209 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.424621959344 | (37.7437522091261, -122.424621959344) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
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 | |||
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 | |||
6070 | 519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | 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 | |||
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 | |||
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 | |||
6605 | 528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | 2 | 4 | 7 | 28859 | 19 | |||
19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 | |||
19257 | 531 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.7527490975863 | -122.408903610932 | (37.7527490975863, -122.408903610932) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );