trees

154 rows where Fire Prevention Districts = 3 and qSpecies_id = 54 sorted by YCoord

✎ 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)
144865 142962 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 192 Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009928.7622 2121093.4626 37.8046779485644 -122.409881772835 (37.8046779485644, -122.409881772835) 3 1 10 308 23
151577 142960 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 180 Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009952.201 2121096.811 37.8046884559914 -122.409800896711 (37.8046884559914, -122.409800896711) 3 1 10 308 23
173201 142961 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 188 Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009941.6774 2121096.811 37.8046878662366 -122.409837314827 (37.8046878662366, -122.409837314827) 3 1 10 308 23
166162 142959 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 178 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009960.8111 2121097.7677 37.8046915653635 -122.409771168052 (37.8046915653635, -122.409771168052) 3 1 10 308 23
116180 142958 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 172 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009982.8149 2121100.1594 37.8046993654404 -122.40969519031 (37.8046993654404, -122.40969519031) 3 1 10 308 23
191595 142969 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 155 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010117.5609 2121101.8588 37.8047115814823 -122.409229006305 (37.8047115814823, -122.409229006305) 3 1 10 308 23
98500 143247 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 153 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010131.5523 2121103.7243 37.8047174875245 -122.40918071917 (37.8047174875245, -122.40918071917) 3 1 10 308 23
29651 142950 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 156 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010083.0275 2121115.7055 37.8047476663275 -122.409349490891 (37.8047476663275, -122.409349490891) 3 1 10 308 23
57394 142946 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 154 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010096.4211 2121116.6622 37.8047510435874 -122.409303208326 (37.8047510435874, -122.409303208326) 3 1 10 308 23
45707 142945 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 152 PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010109.3364 2121119.0539 37.8047583341863 -122.409258682298 (37.8047583341863, -122.409258682298) 3 1 10 308 23
159446 142953 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 19 Bellair Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010052.6528 2121119.7714 37.804757128417 -122.409454893216 (37.804757128417, -122.409454893216) 3 1 10 308 23
172748 142944 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 152 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010124.6433 2121121.924 37.8047670723213 -122.409205913626 (37.8047670723213, -122.409205913626) 3 1 10 308 23
80867 59153 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 Bellair Pl 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/1982 12:00:00 AM 11   Permit Number 19779 6010063.4155 2121130.5341 37.8047872831513 -122.409418407658 (37.8047872831513, -122.409418407658) 3 1 10 308 23
148028 142943 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 112 PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010269.581 2121139.6226 37.8048237870919 -122.408705588917 (37.8048237870919, -122.408705588917) 3 1 10 308 23
38348 142947 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 21 Bellair Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010050.2611 2121139.8618 37.8048121576562 -122.40946458873 (37.8048121576562, -122.40946458873) 3 1 10 308 23
78294 142948 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 BELLAIR PL 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010061.9805 2121140.5793 37.8048147843729 -122.409424083009 (37.8048147843729, -122.409424083009) 3 1 10 308 23
65586 59151 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 112 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/1980 12:00:00 AM 13   Permit Number 18460 6010290.1497 2121142.971 37.8048341329685 -122.408634644798 (37.8048341329685, -122.408634644798) 3 1 10 308 23
123304 143227 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 106 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010308.3267 2121146.7978 37.8048456584244 -122.408572011197 (37.8048456584244, -122.408572011197) 3 1 10 308 23
46642 142949 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 BELLAIR PL 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010058.1538 2121167.8448 37.8048894342531 -122.40943925119 (37.8048894342531, -122.40943925119) 3 1 10 308 23
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
20967 64425 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 259 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/1988 12:00:00 AM 9   Permit Number 25277 6010096.4211 2121261.5999 37.8051490065079 -122.409313442808 (37.8051490065079, -122.409313442808) 3 1 10 308 23
131288 53752 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 251 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/1972 12:00:00 AM 13   Permit Number 9432 6010125.6 2121266.3833 37.8051637752792 -122.409212803017 (37.8051637752792, -122.409212803017) 3 1 10 308 23
169613 143218 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 251 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010143.2987 2121269.7317 37.8051739606787 -122.409151790672 (37.8051739606787, -122.409151790672) 3 1 10 308 23
126969 143217 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 235 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010187.3061 2121274.0368 37.80518824668 -122.40899980098 (37.80518824668, -122.40899980098) 3 1 10 308 23
165733 143210 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010365.1796 2121277.1884 37.8052068625476 -122.408384467587 (37.8052068625476, -122.408384467587) 3 1 10 308 23
126823 143211 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010376.5969 2121289.0448 37.8052400566335 -122.408345793229 (37.8052400566335, -122.408345793229) 3 1 10 308 23
95252 143212 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010402.9445 2121293.4361 37.8052535894305 -122.408254923564 (37.8052535894305, -122.408254923564) 3 1 10 308 23
127974 143213 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010427.9747 2121297.8273 37.8052670481181 -122.40816861291 (37.8052670481181, -122.40816861291) 3 1 10 308 23
72010 56572 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 238 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     20     6010130.9034 2121308.9776 37.805281025756 -122.409197457422 (37.805281025756, -122.409197457422) 3 1 10 308 23
155158 143189 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010358.1536 2121339.5444 37.8053776832044 -122.408413183131 (37.8053776832044, -122.408413183131) 3 1 10 308 23
61057 143188 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010371.7665 2121341.3009 37.8053832684295 -122.40836619766 (37.8053832684295, -122.40836619766) 3 1 10 308 23
16546 143187 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010390.2098 2121342.6183 37.8053879184635 -122.408302464879 (37.8053879184635, -122.408302464879) 3 1 10 308 23
84580 143186 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010406.8966 2121345.6921 37.805397292747 -122.408244934675 (37.805397292747, -122.408244934675) 3 1 10 308 23
132656 143185 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010419.6313 2121347.0095 37.8054016230717 -122.408200957332 (37.8054016230717, -122.408200957332) 3 1 10 308 23
167831 97937 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2011 12:00:00 AM 8 3x3 Permit Number 768327 6009817.588 2121415.668 37.8055564131765 -122.410289267199 (37.8055564131765, -122.410289267199) 3 1 10 308 23
181493 143163 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009857.4165 2121454.9705 37.8056665605493 -122.410154211058 (37.8056665605493, -122.410154211058) 3 1 10 308 23
100156 143164 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009854.6792 2121476.1846 37.8057246557504 -122.410165182597 (37.8057246557504, -122.410165182597) 3 1 10 308 23
40786 143180 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 37 MIDWAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010061.0151 2121485.1789 37.8057609150954 -122.409451758875 (37.8057609150954, -122.409451758875) 3 1 10 308 23
21039 97936 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009809.8586 2121486.2629 37.8057498158932 -122.410321003577 (37.8057498158932, -122.410321003577) 3 1 10 308 23
34527 143179 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 37 MIDWAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010057.031 2121502.7089 37.8058088248802 -122.409466784469 (37.8058088248802, -122.409466784469) 3 1 10 308 23
135675 97935 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009806.2516 2121504.2981 37.8057991338594 -122.410334760405 (37.8057991338594, -122.410334760405) 3 1 10 308 23
21747 143165 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009847.836 2121509.3744 37.8058154030924 -122.410191209337 (37.8058154030924, -122.410191209337) 3 1 10 308 23
45716 97934 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009804.1904 2121525.9403 37.8058584423979 -122.410343422594 (37.8058584423979, -122.410343422594) 3 1 10 308 23
49487 143166 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009846.1251 2121530.2463 37.8058726162247 -122.410198604722 (37.8058726162247, -122.410198604722) 3 1 10 308 23
41625 142631 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009683.097 2121540.8838 37.8058926846956 -122.410763542627 (37.8058926846956, -122.410763542627) 3 1 10 308 23
101324 142632 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009699.071 2121543.9755 37.8059020693628 -122.410708480373 (37.8059020693628, -122.410708480373) 3 1 10 308 23
50284 142633 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009714.0145 2121546.0367 37.8059085667329 -122.410656911507 (37.8059085667329, -122.410656911507) 3 1 10 308 23
37790 142634 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009751.1154 2121551.1896 37.8059247953292 -122.410528881628 (37.8059247953292, -122.410528881628) 3 1 10 308 23
104792 142635 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009773.7882 2121554.2814 37.8059345556962 -122.410450636982 (37.8059345556962, -122.410450636982) 3 1 10 308 23
26414 143167 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 195 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009865.9706 2121568.5686 37.8059789520686 -122.410132633272 (37.8059789520686, -122.410132633272) 3 1 10 308 23
22696 143168 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009887.869 2121571.9902 37.8059895743176 -122.410057091761 (37.8059895743176, -122.410057091761) 3 1 10 308 23
51491 143169 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 185 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009906.0036 2121573.3589 37.8059943488203 -122.4099944305 (37.8059943488203, -122.4099944305) 3 1 10 308 23
167542 143170 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 179 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009922.0853 2121576.7805 37.8060046449874 -122.409939018662 (37.8060046449874, -122.409939018662) 3 1 10 308 23
185698 143162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009943.6415 2121579.1756 37.8060124294215 -122.409864588833 (37.8060124294215, -122.409864588833) 3 1 10 308 23

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