trees
3,267 rows where qSpecies_id = 67 sorted by Neighborhoods (old) descending
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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23298 | 4375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | 2 | 7 | 5 | 63 | 7 | |||
| 25786 | 4863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000706.81411 | 2098191.78506 | 37.7412745606821 | -122.440151887408 | (37.7412745606821, -122.440151887408) | 2 | 7 | 5 | 63 | 7 | |||
| 28679 | 22814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 2X2 | 5998883.46926 | 2099792.01198 | 37.7455644233811 | -122.446571447686 | (37.7455644233811, -122.446571447686) | 2 | 7 | 5 | 63 | 7 | |||
| 29827 | 4856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 9 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6000665.42788 | 2098259.03827 | 37.7414568658316 | -122.440299807886 | (37.7414568658316, -122.440299807886) | 2 | 7 | 5 | 63 | 7 | |||
| 33007 | 222227 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2720 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002357.71601 | 2096152.90491 | 37.7357701179964 | -122.434297928607 | (37.7357701179964, -122.434297928607) | 2 | 7 | 5 | 63 | 7 | |||
| 33902 | 4872 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6000821.7829322 | 2098156.9001957 | 37.7411853197784 | -122.439751866369 | (37.7411853197784, -122.439751866369) | 2 | 7 | 5 | 63 | 7 | |||
| 35319 | 220974 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000839.96017 | 2097863.85747 | 37.7403817281246 | -122.439668012568 | (37.7403817281246, -122.439668012568) | 2 | 7 | 5 | 63 | 7 | |||
| 38427 | 1925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001058.61282 | 2097389.17311 | 37.7390907990037 | -122.438877991419 | (37.7390907990037, -122.438877991419) | 2 | 7 | 5 | 63 | 7 | |||
| 40168 | 222476 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1740 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003954.39861 | 2098124.10752 | 37.7412730893894 | -122.428918064524 | (37.7412730893894, -122.428918064524) | 2 | 7 | 5 | 63 | 7 | |||
| 41617 | 222490 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 235 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004056.09987 | 2097637.96008 | 37.7399439957187 | -122.428531773318 | (37.7399439957187, -122.428531773318) | 2 | 7 | 5 | 63 | 7 | |||
| 44893 | 4868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 40 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6000785.76982 | 2098130.67734 | 37.7411112680693 | -122.439874506828 | (37.7411112680693, -122.439874506828) | 2 | 7 | 5 | 63 | 7 | |||
| 48844 | 222489 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004078.33826 | 2097619.67299 | 37.7398950420102 | -122.428453579085 | (37.7398950420102, -122.428453579085) | 2 | 7 | 5 | 63 | 7 | |||
| 51026 | 222481 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 30 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002674.86782 | 2095992.93467 | 37.7353488728466 | -122.433189985429 | (37.7353488728466, -122.433189985429) | 2 | 7 | 5 | 63 | 7 | |||
| 52595 | 4853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6000632.86051 | 2098307.82133 | 37.7415889582704 | -122.440415912169 | (37.7415889582704, -122.440415912169) | 2 | 7 | 5 | 63 | 7 | |||
| 52683 | 222468 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 228 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004116.23174 | 2097638.19306 | 37.7399480381579 | -122.428323878867 | (37.7399480381579, -122.428323878867) | 2 | 7 | 5 | 63 | 7 | |||
| 52706 | 222218 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 20 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002041.40843 | 2096409.06331 | 37.7364555111172 | -122.435409844101 | (37.7364555111172, -122.435409844101) | 2 | 7 | 5 | 63 | 7 | |||
| 54702 | 222206 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 245 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004627.77227 | 2096895.80624 | 37.7379385444269 | -122.426502335314 | (37.7379385444269, -122.426502335314) | 2 | 7 | 5 | 63 | 7 | |||
| 55663 | 222488 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 195 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004318.20624 | 2097516.66584 | 37.7396257787037 | -122.427616878624 | (37.7396257787037, -122.427616878624) | 2 | 7 | 5 | 63 | 7 | |||
| 57668 | 64314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25131 | 6004545.85418713 | 2097571.72864017 | 37.739789842685 | -122.426833689992 | (37.739789842685, -122.426833689992) | 2 | 7 | 5 | 63 | 7 | ||
| 59698 | 22832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 96 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999484.67049 | 2098974.10299 | 37.7433529640774 | -122.44443382318 | (37.7433529640774, -122.44443382318) | 2 | 7 | 5 | 63 | 7 | |||
| 60182 | 4857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 9 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000644.55264 | 2098284.20496 | 37.7415247790377 | -122.440373791542 | (37.7415247790377, -122.440373791542) | 2 | 7 | 5 | 63 | 7 | |||
| 60397 | 4858 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 16 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6000671.66564 | 2098216.18353 | 37.7413395519912 | -122.440275167373 | (37.7413395519912, -122.440275167373) | 2 | 7 | 5 | 63 | 7 | |||
| 63962 | 222495 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003377.38503 | 2097755.83349 | 37.7402292165951 | -122.430886896324 | (37.7402292165951, -122.430886896324) | 2 | 7 | 5 | 63 | 7 | |||
| 65569 | 222473 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1745 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003997.11416 | 2098016.88459 | 37.7409810974917 | -122.428762727341 | (37.7409810974917, -122.428762727341) | 2 | 7 | 5 | 63 | 7 | |||
| 67478 | 5138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2x2 | 6002423.32112 | 2095400.94978 | 37.7337091452519 | -122.434017371606 | (37.7337091452519, -122.434017371606) | 2 | 7 | 5 | 63 | 7 | ||
| 67659 | 222215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001776.44138 | 2096744.48692 | 37.7373614548555 | -122.436349944101 | (37.7373614548555, -122.436349944101) | 2 | 7 | 5 | 63 | 7 | |||
| 71446 | 222214 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001802.17955 | 2096934.1662 | 37.7378837325538 | -122.436274526045 | (37.7378837325538, -122.436274526045) | 2 | 7 | 5 | 63 | 7 | |||
| 72066 | 222226 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6002037.75303 | 2096506.93843 | 37.7367240459777 | -122.43542948168 | (37.7367240459777, -122.43542948168) | 2 | 7 | 5 | 63 | 7 | |||
| 72863 | 4882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 2X2 | 6000675.0021603 | 2098204.4094064 | 37.7413074129943 | -122.440262786724 | (37.7413074129943, -122.440262786724) | 2 | 7 | 5 | 63 | 7 | |||
| 74364 | 4866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6000802.37164 | 2098157.55359 | 37.7411860089349 | -122.439819030347 | (37.7411860089349, -122.439819030347) | 2 | 7 | 5 | 63 | 7 | |||
| 76092 | 5090 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2599 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002264.68723 | 2096743.24247 | 37.7373857680401 | -122.434661764636 | (37.7373857680401, -122.434661764636) | 2 | 7 | 5 | 63 | 7 | |||
| 78928 | 222493 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 265 Beacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002922.33421 | 2097866.26624 | 37.7405066457633 | -122.432468163499 | (37.7405066457633, -122.432468163499) | 2 | 7 | 5 | 63 | 7 | |||
| 80753 | 4859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 17 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000712.83991 | 2098222.90131 | 37.7413603416151 | -122.440133283139 | (37.7413603416151, -122.440133283139) | 2 | 7 | 5 | 63 | 7 | |||
| 82294 | 4874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000875.46201 | 2097999.81649 | 37.7407570602008 | -122.439555005583 | (37.7407570602008, -122.439555005583) | 2 | 7 | 5 | 63 | 7 | |||
| 82686 | 222470 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 242 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004040.31576 | 2097695.00767 | 37.7400997421158 | -122.428590413633 | (37.7400997421158, -122.428590413633) | 2 | 7 | 5 | 63 | 7 | |||
| 87302 | 117121 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 CRAGS CT | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000924 | 2097953 | 37.7406312755223 | -122.439383824913 | (37.7406312755223, -122.439383824913) | 2 | 7 | 5 | 63 | 7 | ||||
| 89325 | 4864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1992 12:00:00 AM | 25 | 2X2 | 6000739.41947 | 2098202.35217 | 37.7413054316983 | -122.440039907412 | (37.7413054316983, -122.440039907412) | 2 | 7 | 5 | 63 | 7 | ||
| 90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
| 90537 | 222492 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 265 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002907.41416 | 2097886.83375 | 37.7405622733195 | -122.432521219896 | (37.7405622733195, -122.432521219896) | 2 | 7 | 5 | 63 | 7 | |||
| 93292 | 222220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002032.99126 | 2096345.37329 | 37.7362801549975 | -122.4354343911 | (37.7362801549975, -122.4354343911) | 2 | 7 | 5 | 63 | 7 | |||
| 96516 | 34357 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38113 | 6004544.96387342 | 2098197.10530749 | 37.741506934238 | -122.426881295332 | (37.741506934238, -122.426881295332) | 2 | 7 | 5 | 63 | 7 | ||
| 97341 | 4875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6000876.37429 | 2097986.48313 | 37.7407205018559 | -122.439550895678 | (37.7407205018559, -122.439550895678) | 2 | 7 | 5 | 63 | 7 | |||
| 98410 | 4877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6000895.2061 | 2098063.61209 | 37.7409333515943 | -122.439491310182 | (37.7409333515943, -122.439491310182) | 2 | 7 | 5 | 63 | 7 | |||
| 99164 | 222209 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 210 Roanoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003552.74606 | 2095989.54132 | 37.7353893162721 | -122.430154593682 | (37.7353893162721, -122.430154593682) | 2 | 7 | 5 | 63 | 7 | |||
| 100054 | 222207 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 210 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003536.54045 | 2096012.62745 | 37.7354517876606 | -122.430212268982 | (37.7354517876606, -122.430212268982) | 2 | 7 | 5 | 63 | 7 | |||
| 102007 | 222471 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1789 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004011.3186 | 2097777.01353 | 37.7403232703892 | -122.428696518347 | (37.7403232703892, -122.428696518347) | 2 | 7 | 5 | 63 | 7 | |||
| 103267 | 222480 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 330 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6001448.68136 | 2096229.06835 | 37.7359276063686 | -122.437446262629 | (37.7359276063686, -122.437446262629) | 2 | 7 | 5 | 63 | 7 | |||
| 104139 | 222213 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001840.39332 | 2096931.65856 | 37.7378790183133 | -122.436142223179 | (37.7378790183133, -122.436142223179) | 2 | 7 | 5 | 63 | 7 | |||
| 105624 | 222469 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 232 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004093.06653 | 2097657.73892 | 37.740000395801 | -122.428405367328 | (37.740000395801, -122.428405367328) | 2 | 7 | 5 | 63 | 7 | |||
| 110380 | 222484 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 59 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002447.27077 | 2096535.42009 | 37.7368254993903 | -122.434015637735 | (37.7368254993903, -122.434015637735) | 2 | 7 | 5 | 63 | 7 | |||
| 110447 | 220970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000907.15737 | 2097980.81519 | 37.740706690971 | -122.439444053516 | (37.740706690971, -122.439444053516) | 2 | 7 | 5 | 63 | 7 | |||
| 111242 | 222466 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 59 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004302.59353 | 2097925.51502 | 37.7407475021851 | -122.427699983161 | (37.7407475021851, -122.427699983161) | 2 | 7 | 5 | 63 | 7 | |||
| 111978 | 121609 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 222 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004147 | 2097629 | 37.7399245370794 | -122.428216839981 | (37.7399245370794, -122.428216839981) | 2 | 7 | 5 | 63 | 7 | ||||
| 115635 | 222224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 17 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002068.21212 | 2096412.04395 | 37.7364652174828 | -122.4353173857 | (37.7364652174828, -122.4353173857) | 2 | 7 | 5 | 63 | 7 | |||
| 115972 | 222479 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001753.48392 | 2096571.75813 | 37.7368858771861 | -122.436416959778 | (37.7368858771861, -122.436416959778) | 2 | 7 | 5 | 63 | 7 | |||
| 116247 | 222472 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1749 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003998.16336 | 2097996.3275 | 37.7409247118133 | -122.428757634473 | (37.7409247118133, -122.428757634473) | 2 | 7 | 5 | 63 | 7 | |||
| 116378 | 4854 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 208X Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6000949.9317226 | 2097825.576354 | 37.7402828758816 | -122.439285032066 | (37.7402828758816, -122.439285032066) | 2 | 7 | 5 | 63 | 7 | |||
| 117064 | 222222 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001990.31497 | 2096295.82426 | 37.7361416809841 | -122.43557839683 | (37.7361416809841, -122.43557839683) | 2 | 7 | 5 | 63 | 7 | |||
| 117946 | 4876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Crags Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6000878.44646 | 2097957.44454 | 37.7406408866608 | -122.439541649751 | (37.7406408866608, -122.439541649751) | 2 | 7 | 5 | 63 | 7 | |||
| 118886 | 24477 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.91893 | 2096714.27726 | 37.7373093148834 | -122.434472190244 | (37.7373093148834, -122.434472190244) | 2 | 7 | 5 | 63 | 7 | ||
| 120466 | 56684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52127 | 6004114.02111143 | 2097584.45844202 | 37.7398003700762 | -122.428327693503 | (37.7398003700762, -122.428327693503) | 2 | 7 | 5 | 63 | 7 | |||
| 121702 | 222491 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 270 Beacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002967.78522 | 2097861.36319 | 37.7404957603754 | -122.432310661632 | (37.7404957603754, -122.432310661632) | 2 | 7 | 5 | 63 | 7 | |||
| 122867 | 4881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6000907.7136 | 2097921.62837 | 37.74054420955 | -122.439437888659 | (37.74054420955, -122.439437888659) | 2 | 7 | 5 | 63 | 7 | |||
| 125044 | 222465 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 178 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004391.5246 | 2097555.11516 | 37.7397354986911 | -122.42736611348 | (37.7397354986911, -122.42736611348) | 2 | 7 | 5 | 63 | 7 | |||
| 126760 | 22807 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.7455120267519 | -122.446479507446 | (37.7455120267519, -122.446479507446) | 2 | 7 | 5 | 63 | 7 | ||
| 132834 | 220805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | 2 | 7 | 5 | 63 | 7 | |||
| 134125 | 220969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 40 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999075.26007 | 2099482.01181 | 37.7447241909826 | -122.445885975579 | (37.7447241909826, -122.445885975579) | 2 | 7 | 5 | 63 | 7 | |||
| 135114 | 222223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001970.75929 | 2096277.14001 | 37.7360892676144 | -122.435644672379 | (37.7360892676144, -122.435644672379) | 2 | 7 | 5 | 63 | 7 | |||
| 136984 | 117120 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 CRAGS CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000924 | 2097953 | 37.7406312755223 | -122.439383824913 | (37.7406312755223, -122.439383824913) | 2 | 7 | 5 | 63 | 7 | |||
| 142583 | 86958 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000699 | 2098232 | 37.7413845365366 | -122.440181788906 | (37.7413845365366, -122.440181788906) | 2 | 7 | 5 | 63 | 7 | |||
| 146859 | 17233 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6001155.38757 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | 2 | 7 | 5 | 63 | 7 | |||
| 147767 | 9373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 292 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x4 | 6001116.19267 | 2097967.75303 | 37.7406827195388 | -122.438720354687 | (37.7406827195388, -122.438720354687) | 2 | 7 | 5 | 63 | 7 | |||
| 147920 | 222219 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 20 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6002042.39903 | 2096388.30459 | 37.7363985687262 | -122.435404934686 | (37.7363985687262, -122.435404934686) | 2 | 7 | 5 | 63 | 7 | |||
| 151211 | 222221 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002020.50321 | 2096325.12887 | 37.7362238592494 | -122.435476119628 | (37.7362238592494, -122.435476119628) | 2 | 7 | 5 | 63 | 7 | |||
| 152635 | 222212 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1012 Chenery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6000957.79216 | 2096197.54851 | 37.7358131397705 | -122.439141199604 | (37.7358131397705, -122.439141199604) | 2 | 7 | 5 | 63 | 7 | ||||
| 155010 | 4369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001020.80227 | 2096135.40108 | 37.7356460826069 | -122.438918897095 | (37.7356460826069, -122.438918897095) | 2 | 7 | 5 | 63 | 7 | |||
| 155389 | 222487 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 183 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004373.50869 | 2097518.96538 | 37.7396352206895 | -122.427425830257 | (37.7396352206895, -122.427425830257) | 2 | 7 | 5 | 63 | 7 | |||
| 155981 | 222217 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002025.85337 | 2096457.93156 | 37.7365888086132 | -122.435467119213 | (37.7365888086132, -122.435467119213) | 2 | 7 | 5 | 63 | 7 | |||
| 156197 | 4878 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 2X2 | 6000744.9101647 | 2098152.0241158 | 37.7411675553146 | -122.440017314698 | (37.7411675553146, -122.440017314698) | 2 | 7 | 5 | 63 | 7 | |||
| 156553 | 222486 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 124 Moreland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 2ft | 6002283.64402 | 2097512.32666 | 37.7394985713917 | -122.4346512003 | (37.7394985713917, -122.4346512003) | 2 | 7 | 5 | 63 | 7 | |||
| 157581 | 220972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000712.35898 | 2098186.93596 | 37.741261561876 | -122.440132367617 | (37.741261561876, -122.440132367617) | 2 | 7 | 5 | 63 | 7 | |||
| 158634 | 222474 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003992.66942 | 2098122.82994 | 37.7412717475836 | -122.428785646536 | (37.7412717475836, -122.428785646536) | 2 | 7 | 5 | 63 | 7 | |||
| 159907 | 5112 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2711 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4X4 | 6002382.81986 | 2096188.04057 | 37.7358680173011 | -122.434213645952 | (37.7358680173011, -122.434213645952) | 2 | 7 | 5 | 63 | 7 | |||
| 160608 | 220971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 43 Crags Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000816.13409 | 2098147.80035 | 37.7411600122143 | -122.43977074574 | (37.7411600122143, -122.43977074574) | 2 | 7 | 5 | 63 | 7 | |||
| 164942 | 5058 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5521 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001859.76299 | 2097506.95056 | 37.7394597368712 | -122.436116409072 | (37.7394597368712, -122.436116409072) | 2 | 7 | 5 | 63 | 7 | |||
| 165031 | 220804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 286 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6002911.89345 | 2096223.73908 | 37.7359960519744 | -122.432386979878 | (37.7359960519744, -122.432386979878) | 2 | 7 | 5 | 63 | 7 | ||||
| 166369 | 220806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6003687.50559 | 2095763.31168 | 37.7347757726743 | -122.429672549851 | (37.7347757726743, -122.429672549851) | 2 | 7 | 5 | 63 | 7 | |||
| 172932 | 222478 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001753.94319 | 2096593.95124 | 37.7369468404176 | -122.436416959794 | (37.7369468404176, -122.436416959794) | 2 | 7 | 5 | 63 | 7 | |||
| 174028 | 64310 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1701 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25121 | 6003416.05373745 | 2098325.908914 | 37.7417967033139 | -122.430793867733 | (37.7417967033139, -122.430793867733) | 2 | 7 | 5 | 63 | 7 | ||
| 178811 | 222477 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 170 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004008.19179 | 2097360.33855 | 37.7391789991224 | -122.42867763436 | (37.7391789991224, -122.42867763436) | 2 | 7 | 5 | 63 | 7 | |||
| 179527 | 222210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 286 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6002911.44026 | 2096221.9598 | 37.7359911407813 | -122.432388419696 | (37.7359911407813, -122.432388419696) | 2 | 7 | 5 | 63 | 7 | ||||
| 179980 | 222463 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1826 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004554.14375 | 2098144.87884 | 37.7413640513199 | -122.426845835893 | (37.7413640513199, -122.426845835893) | 2 | 7 | 5 | 63 | 7 | |||
| 180064 | 222482 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002431.77618 | 2096257.15216 | 37.736060560354 | -122.434049323619 | (37.736060560354, -122.434049323619) | 2 | 7 | 5 | 63 | 7 | |||
| 182235 | 222225 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002045.81113 | 2096484.61958 | 37.7366632212164 | -122.435400025297 | (37.7366632212164, -122.435400025297) | 2 | 7 | 5 | 63 | 7 | |||
| 182691 | 4855 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 208X Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6000949.9317226 | 2097825.576354 | 37.7402828758816 | -122.439285032066 | (37.7402828758816, -122.439285032066) | 2 | 7 | 5 | 63 | 7 | |||
| 183201 | 222208 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 210 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003544.56301 | 2096002.60397 | 37.7354247198598 | -122.430183817131 | (37.7354247198598, -122.430183817131) | 2 | 7 | 5 | 63 | 7 | |||
| 183231 | 222464 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 162 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004463.48445 | 2097560.63727 | 37.7397547306933 | -122.427117700038 | (37.7397547306933, -122.427117700038) | 2 | 7 | 5 | 63 | 7 | |||
| 185719 | 222462 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004552.52358 | 2098188.18805 | 37.7414828769245 | -122.426854521529 | (37.7414828769245, -122.426854521529) | 2 | 7 | 5 | 63 | 7 | |||
| 187669 | 4871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 48 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000859.63404 | 2098067.6041 | 37.7409422881585 | -122.439614591049 | (37.7409422881585, -122.439614591049) | 2 | 7 | 5 | 63 | 7 | |||
| 191016 | 222483 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2617 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002309.54618 | 2096507.28827 | 37.7367404388252 | -122.434489800761 | (37.7367404388252, -122.434489800761) | 2 | 7 | 5 | 63 | 7 |
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) );