trees

41 rows where Fire Prevention Districts = 2 and qSpecies_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
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
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
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
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
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
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
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
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
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
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
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
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

CSV options: 

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)
);