Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, PlantDate, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186 | 186 | 138359 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.43386429175101 | (37.7860784126894, -122.433864291751) | |||
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 378 | 378 | 138112 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6004508.5013 | 2114699.1479 | 37.7868155327596 | -122.428183141793 | (37.7868155327596, -122.428183141793) | |||
| 894 | 894 | 15433 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | |||
| 935 | 935 | 143018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 404 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 0ft | 6010387.0782 | 2120648.4016 | 37.80348159588821 | -122.40826430805402 | (37.8034815958882, -122.408264308054) | |||
| 1121 | 1121 | 13143 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | |||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) | ||
| 1363 | 1363 | 21606 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | |||
| 1468 | 1468 | 247377 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1470 | 1470 | 138091 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 15 | Width 0ft | 6003632.0 | 2114586.0 | 37.7864552256154 | -122.43120755079399 | (37.7864552256154, -122.431207550794) | ||
| 1528 | 1528 | 13126 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.42964001675399 | (37.8005454550984, -122.429640016754) | |||
| 1644 | 1644 | 14813 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.778579430545896 | -122.431524477475 | (37.7785794305459, -122.431524477475) | |||
| 1775 | 1775 | 245411 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2794 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | |||
| 1906 | 1906 | 244384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 257 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6005748.2149 | 2110309.2015 | 37.7748318806023 | -122.423581789147 | (37.7748318806023, -122.423581789147) | |||
| 2054 | 2054 | 143144 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2150 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002035.2938 | 2119489.3913 | 37.799828054976395 | -122.437082936374 | (37.7998280549764, -122.437082936374) | |||
| 2056 | 2056 | 143141 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2140 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6002153.6152 | 2119503.7145 | 37.7998741075374 | -122.436674526744 | (37.7998741075374, -122.436674526744) | |||
| 2173 | 2173 | 21585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | |||
| 2207 | 2207 | 244533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1588 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 5998589.1758 | 2108666.333 | 37.7699142890018 | -122.448227967728 | (37.7699142890018, -122.448227967728) | |||
| 2225 | 2225 | 7163 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.776662267069895 | -122.43127518600001 | (37.7766622670699, -122.431275186) | |||
| 2890 | 2890 | 17680 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.43523443397801 | (37.7795688238035, -122.435234433978) | |||
| 2903 | 2903 | 13280 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.44322102307699 | (37.7990441048198, -122.443221023077) | ||
| 3154 | 3154 | 142517 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 402 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6010454.8754 | 2118953.3694 | 37.798831249998 | -122.40791009059299 | (37.798831249998, -122.407910090593) | |||
| 3729 | 3729 | 18005 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.787094464568796 | -122.43983396035101 | (37.7870944645688, -122.439833960351) | |||
| 4022 | 4022 | 22785 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.44009404075399 | (37.7793954847522, -122.440094040754) | |||
| 4497 | 4497 | 13125 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | ||
| 4602 | 4602 | 245382 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005277.267000001 | 2096556.8057 | 37.7370444205252 | -122.42423260748899 | (37.7370444205252, -122.424232607489) | |||
| 4603 | 4603 | 142513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 419 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6010363.8889 | 2118953.3694 | 37.798826155678796 | -122.408224935007 | (37.7988261556788, -122.408224935007) | |||
| 4606 | 4606 | 142512 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 427 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010331.5039 | 2118981.6421 | 37.798901972160294 | -122.40833899341601 | (37.7989019721603, -122.408338993416) | |||
| 4924 | 4924 | 143020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 560 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 5252 | 5252 | 17675 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.779441734619205 | -122.435215744209 | (37.7794417346192, -122.435215744209) | |||
| 5332 | 5332 | 10639 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.43074666505301 | (37.7758276754833, -122.430746665053) | |||
| 5342 | 5342 | 17679 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | |||
| 5382 | 5382 | 7155 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 710 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003553.4142 | 2110901.6518 | 37.776334472306 | -122.431216355856 | (37.776334472306, -122.431216355856) | |||
| 5422 | 5422 | 4684 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.801626533850204 | -122.411938460907 | (37.8016265338502, -122.411938460907) | |||
| 5554 | 5554 | 21709 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x9 | 6003440.4648 | 2114551.568 | 37.786349828094295 | -122.43186775477301 | (37.7863498280943, -122.431867754773) | |||
| 5648 | 5648 | 7179 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.777196523521795 | -122.431551070298 | (37.7771965235218, -122.431551070298) | |||
| 5653 | 5653 | 12271 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | |||
| 5748 | 5748 | 6994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003272.597999999 | 2110360.7630000003 | 37.77483340788321 | -122.43214914086201 | (37.7748334078832, -122.432149140862) | |||
| 5822 | 5822 | 18009 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.787117383440794 | -122.440724211427 | (37.7871173834408, -122.440724211427) | |||
| 5865 | 5865 | 13184 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002517.9206 | 2119475.0682 | 37.799816148716296 | -122.435411844948 | (37.7998161487163, -122.435411844948) | |||
| 5974 | 5974 | 21668 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4X4 | 6004178.0557 | 2114647.4926 | 37.7866549980826 | -122.42932272146601 | (37.7866549980826, -122.429322721466) | |||
| 6034 | 6034 | 17999 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2663 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001215.9923 | 2114878.7551 | 37.7871218470279 | -122.439587308087 | (37.7871218470279, -122.439587308087) | |||
| 6061 | 6061 | 14540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 712 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999232.8618 | 2110380.1211 | 37.7746566927117 | -122.44612477022 | (37.7746566927117, -122.44612477022) | |||
| 6065 | 6065 | 13190 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | ||
| 6126 | 6126 | 7180 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.43157866908199 | (37.7772995333232, -122.431578669082) | |||
| 6144 | 6144 | 7206 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003460.3469 | 2111580.5338 | 37.778193239457295 | -122.431586779834 | (37.7781932394573, -122.431586779834) | |||
| 6214 | 6214 | 23797 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | |||
| 6264 | 6264 | 18011 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.786993901953394 | -122.440676225149 | (37.7869939019534, -122.440676225149) | |||
| 6452 | 6452 | 13171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1940X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003096.45 | 2119636.9817 | 37.8002935599258 | -122.433421496602 | (37.8002935599258, -122.433421496602) | |||
| 6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
| 6639 | 6639 | 12264 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.42634878470301 | (37.7772098348265, -122.426348784703) | |||
| 6652 | 6652 | 13197 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2114 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002204.6803 | 2119511.1874 | 37.799897528014704 | -122.436498357806 | (37.7998975280147, -122.436498357806) | |||
| 6666 | 6666 | 7250 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1990 12:00:00 AM | 12 | 4X4 | 6003025.9615 | 2114308.2396 | 37.7856582037536 | -122.43328443554199 | (37.7856582037536, -122.433284435542) | ||
| 6938 | 6938 | 18020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2723 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000792.5524 | 2114820.8321 | 37.786938696374 | -122.44104815631201 | (37.786938696374, -122.441048156312) | |||
| 7042 | 7042 | 13093 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005391.575 | 2119956.3245 | 37.8013003370098 | -122.42550219218 | (37.8013003370098, -122.42550219218) | |||
| 7272 | 7272 | 14849 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1344 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002734.6717 | 2111669.6476 | 37.7783967656122 | -122.43410352432501 | (37.7783967656122, -122.434103524325) | |||
| 7298 | 7298 | 7263 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1730 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003079.0359 | 2114300.077 | 37.785638802077706 | -122.433100230123 | (37.7856388020777, -122.433100230123) | |||
| 7334 | 7334 | 12265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 646 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004962.1321 | 2111217.4355 | 37.7772812673791 | -122.42636569465401 | (37.7772812673791, -122.426365694654) | |||
| 7382 | 7382 | 2590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1712 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005179.844 | 2115138.5122 | 37.788059879281505 | -122.42589173782301 | (37.7880598792815, -122.425891737823) | |||
| 7436 | 7436 | 4702 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1989 12:00:00 AM | 30 | 3X3 | 6008773.44 | 2120486.1314 | 37.8029455537581 | -122.413836905739 | (37.8029455537581, -122.413836905739) | ||
| 7444 | 7444 | 7160 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 722 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6003546.1461 | 2110964.1580000003 | 37.7765056869903 | -122.43124596095899 | (37.7765056869903, -122.431245960959) | |||
| 7483 | 7483 | 7265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1740 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003066.7944 | 2114355.8984 | 37.78579137911579 | -122.433146572029 | (37.7857913791158, -122.433146572029) | |||
| 7509 | 7509 | 23794 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003750.8632 | 2112612.5515 | 37.7810433657763 | -122.43065544025299 | (37.7810433657763, -122.430655440253) | |||
| 7601 | 7601 | 9631 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002709.6742 | 2111961.3805 | 37.7791963723972 | -122.434210861246 | (37.7791963723972, -122.434210861246) | |||
| 7675 | 7675 | 2728 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2250 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002761.9846 | 2114804.6298 | 37.7870061862481 | -122.43423321856899 | (37.7870061862481, -122.434233218569) | |||
| 7736 | 7736 | 20147 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1025 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3x3 | 6002893.7013 | 2111823.32 | 37.778827735903604 | -122.433564367127 | (37.7788277359036, -122.433564367127) | ||
| 7852 | 7852 | 14863 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1398 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6002510.6756 | 2111638.0989 | 37.77829742557871 | -122.434876152922 | (37.7782974255787, -122.434876152922) | |||
| 7961 | 7961 | 28067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996427.4656 | 2112840.3465 | 37.7812512181791 | -122.456007038851 | (37.7812512181791, -122.456007038851) | |||
| 8007 | 8007 | 12247 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.42622454699699 | (37.7757881731565, -122.426224546997) | |||
| 8032 | 8032 | 18023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2729 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000744.2415 | 2114813.5523 | 37.786915956134294 | -122.44121477806101 | (37.7869159561343, -122.441214778061) | |||
| 8075 | 8075 | 21657 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1725 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6004318.092999999 | 2114616.1002 | 37.7865767294467 | -122.428835987308 | (37.7865767294467, -122.428835987308) | |||
| 8195 | 8195 | 13291 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999604.2969 | 2119102.6495 | 37.7986276847794 | -122.44546723704599 | (37.7986276847794, -122.445467237046) | |||
| 8268 | 8268 | 10636 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | ||
| 8320 | 8320 | 9641 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002541.4785 | 2111991.5 | 37.77926952525671 | -122.434794873127 | (37.7792695252567, -122.434794873127) | |||
| 8369 | 8369 | 7167 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 761 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003488.931 | 2111020.5633 | 37.776657319429 | -122.431447911846 | (37.776657319429, -122.431447911846) | |||
| 8479 | 8479 | 7161 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | |||
| 8655 | 8655 | 21608 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.786875002060704 | -122.42646540299 | (37.7868750020607, -122.42646540299) | ||
| 8872 | 8872 | 18050 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2832 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000363.8297 | 2114817.6224 | 37.7869054550264 | -122.442531204238 | (37.7869054550264, -122.442531204238) | |||
| 8913 | 8913 | 13286 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | ||
| 8915 | 8915 | 10629 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.775925484701794 | -122.429965440473 | (37.7759254847018, -122.429965440473) | ||
| 8928 | 8928 | 7213 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | |||
| 8969 | 8969 | 8181 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601002 | (37.7770478129311, -122.43721134601) | |||
| 9530 | 9530 | 12248 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004985.727999999 | 2110723.6115 | 37.775926681152896 | -122.42624890215599 | (37.7759266811529, -122.426248902156) | |||
| 9534 | 9534 | 8072 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.778406678029796 | -122.425067563729 | (37.7784066780298, -122.425067563729) | |||
| 10070 | 10070 | 18018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000772.0 | 2114884.0 | 37.7871109684575 | -122.44112379643299 | (37.7871109684575, -122.441123796433) | |||
| 10272 | 10272 | 531 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2847 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.752749097586296 | -122.408903610932 | (37.7527490975863, -122.408903610932) | |||
| 11043 | 11043 | 15768 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.721803449313896 | -122.437092531149 | (37.7218034493139, -122.437092531149) | ||
| 15556 | 15556 | 7384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | |||
| 16043 | 16043 | 7390 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.40628609857299 | (37.7778494726714, -122.406286098573) | |||
| 17018 | 17018 | 4509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.44919964223699 | (37.7715600792218, -122.449199642237) | |||
| 17085 | 17085 | 16938 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 595X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004175.1129 | 2110087.9596 | 37.7741354848182 | -122.42900769942301 | (37.7741354848182, -122.429007699423) | |||
| 17107 | 17107 | 17067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.772511116707605 | -122.441659471159 | (37.7725111167076, -122.441659471159) | |||
| 17156 | 17156 | 16864 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | |||
| 17168 | 17168 | 17084 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.772065998090895 | -122.445177292475 | (37.7720659980909, -122.445177292475) | |||
| 17192 | 17192 | 17024 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001643.357000001 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | |||
| 17194 | 17194 | 5146 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | |||
| 17198 | 17198 | 538 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | |||
| 17292 | 17292 | 540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.75271856860871 | -122.409523875049 | (37.7527185686087, -122.409523875049) | |||
| 17429 | 17429 | 529 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | |||
| 17455 | 17455 | 519 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");